Home / Commands / Get-sqmWaitStatistics
Get-sqmWaitStatistics
Performance sqmSQLTool v1.8.2+
Reads and analyzes SQL Server wait statistics from sys.dm_os_wait_stats.

Examples

Get-sqmWaitStatistics -SqlInstance "SQL01" -TopN 20
Get-sqmWaitStatistics -SqlInstance "SQL01" -TopN 20
$before = Get-sqmWaitStatistics -SqlInstance "SQL01" -SaveSnapshot
$before = Get-sqmWaitStatistics -SqlInstance "SQL01" -SaveSnapshot
    Get-sqmWaitStatistics -SqlInstance "SQL01" -SnapshotBefore $before
← Previous Command
Get-sqmServerUtilization
Next Command →
Invoke-sqmExtendedEvents