Home Forums SQL Server 2008 SQL Server 2008 - General DMV for capturing all SQL Statements instead of just the last RE: DMV for capturing all SQL Statements instead of just the last
DanielP
SSCrazy
Points: 2302
More actions
January 10, 2013 at 9:38 am
#1575870
We had to set up Management Data Warehouse (MDW) to monitor. I was able to trace the SQL Code that was causing the blocking by drilling down the Server Acitviy Report for that time frame. There was a spike in 'locks', just had to drill down on it.