Viewing post 1 (of 1 total)
Easy way to get blocking issues is setup blocking threshold and analyze trace files, also you can use analyze two or more snapshots of sys.dm_db_index_operational_stats to find most locked indexes\tables.
February 24, 2011 at 12:54 pm
#1291240