Get-DaDatabaseIndexStatus
Synopsis
Checks if the Direct Access Database has the index
Syntax
Get-DaDatabaseIndexStatus [[-ConnectionTimeout] <Int32>] [-WhatIf] [-Confirm] [<CommonParameters>]
Description
This function connects to the Windows internal database in order to add the missing index. Not having that index can cause high cpu load on the Server 2012R2 Direct Access server.
Examples
-------------------------- EXAMPLE 1 --------------------------
Get-DaDatabaseIndexStatus
Will retrieve the status of the index and the local computer name
-------------------------- EXAMPLE 2 --------------------------
Get-DaDatabaseIndexStatus -ConnectionTimeout 600
Will retrieve the status of the index and the local computer name and set the timeout to ten minutes. This gives the server more time to complete the request.
Parameters
-ConnectionTimeout
This parameter indicates the timeout in seconds while trying to establish a connection before terminating the attempt and generating an error.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: 1
Default value: None
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 nformation, see about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
Notes
Name: Get-DaDatabaseIndexStatus Author: Jaap Brasser Version: 1.1.0 DateCreated: 2016-04-25 DateUpdated: 2016-08-09 Blog: http://www.jaapbrasser.com