Foloseste scriptul lui Paul Randal (http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/) ca sa te lamuresti de unde sa incepi si sp_whoisactive (http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx) ca sa identifici eventualele query-uri cu probleme. Glenn Berry ofera cateva scripturi care iti pot fi de folos: http://sqlserverperformance.wordpress.com/2013/05/06/sql-server-2008-r2-diagnostic-information-queries-may-2013/
Full text poate pune si el probleme.