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