Add-DaDatabaseIndex

NAME Add-DaDatabaseIndex



SYNOPSIS

Checks if the Direct Access Database has the index





SYNTAX

Add-DaDatabaseIndex [[-ConnectionTimeout] <Int32>] [-WhatIf] [-Confirm] [<CommonParameters>]





DESCRIPTION

This function connects to the Windows internal database in order to create the missing index. This can resolve

high cpu load issues on the Server 2012R2 Direct Access server.





PARAMETERS

-ConnectionTimeout <Int32>

This parameter indicates the timeout in seconds while trying to establish a connection before terminating the

attempt and generating an error.



Required? false

Position? 1

Default value 0

Accept pipeline input? false

Accept wildcard characters? false



-WhatIf [<SwitchParameter>]



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Confirm [<SwitchParameter>]



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



NOTES





Name: Add-DaDatabaseIndex

Author: Jaap Brasser

Version: 1.1.0

DateCreated: 2016-04-25

DateUpdated: 2016-08-09

Blog: http://www.jaapbrasser.com



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Add-DaDatabaseIndex



Description:

Will create the database index that can resolve cpu load issues on the system









-------------------------- EXAMPLE 2 --------------------------



PS C:\\>Add-DaDatabaseIndex -ConnectionTimeout 600



Description:

Will create the database index that can resolve cpu load issues on the system and set the timeout to ten minutes.

This gives the server more time to complete the request.











RELATED LINKS