LatchStatistics

Get-DbaLatchStatistic

Get-DbaLatchStatistic View Source Patrick Flynn (@sqllensman) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves latch contention statistics from SQL Server to identify performance bottlenecks Description Analyzes latch wait statistics from sys.dm_os_latch_stats to help identify latch contention issues that may be causing performance problems. This function implements Paul Randal’s methodology for latch troubleshooting by returning the most significant latch classes based on cumulative wait time percentage.