Check non-BUF Latches (T-SQL)

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.

Latch.zip
 
 
 
 
 
3 Star
(2)
587 times
Add to favorites
Databases
10/8/2013
E-mail Twitter del.icio.us Digg Facebook