I found a very useful posts regarding analysis of currently running SQL queries and high SQL server load in Pinal Dave's blog.
http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/
http://blog.sqlauthority.com/2009/01/02/sql-server-2008-2005-find-longest-running-query-tsql/
Using these tricks the culprit of the high load can be easily indicated.
Until the problem resolution is implemented KILL [session_id] can stop the problematic query w/o server restart or long waiting.
No comments:
Post a Comment