Monday, May 17, 2010

List Currently Executing SQL Queries

http://sam.curren.ws/index.cfm/2007/8/4/Currently-Running-Queries-on-SQL-Server-2005
http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/
http://snippets.dzone.com/posts/show/8429


Notes on status (runnable, running, suspended ...):
Mr. Ashish from scalabilityexperts.com told that SQL OS (?) manages tasks and resource allocation and switches among tasks (recall process scheduling, execution pool in OS)

No comments: