< Back

Get-DaDatabaseIndexStatus

Mon Jan 13, 2020 7:26 pm

NAME 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 establish if the missing index that can cause

high cpu load 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: Get-DaDatabaseIndexStatus

Author: Jaap Brasser

Version: 1.1.0

DateCreated: 2016-04-25

DateUpdated: 2016-08-09

Blog: http://www.jaapbrasser.com



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



PS C:\\>Get-DaDatabaseIndexStatus



Description:

Will retrieve the status of the index and the local computer name









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



PS C:\\>Get-DaDatabaseIndexStatus -ConnectionTimeout 600



Description:

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.











RELATED LINKS