[Script of Oct. 29] Check non-BUF Latches (T-SQL)

  • Article

Script Download: Latch.zip
https://gallery.technet.microsoft.com/scriptcenter/Check-non-BUF-Latches-T-SQL-099b4753

This script will check non-BUF latch information. It waits for a minute and collects the historical latches and instantaneous latches on the instance. If you suspect there is latch contention, you can run this script and troubleshoot based on the results.

You can use this script for troubleshooting when you want to check latch contention in SQL Server.

image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery