Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save qsLI/39fc0b32edfaad7b730f9c40773d7078 to your computer and use it in GitHub Desktop.
Save qsLI/39fc0b32edfaad7b730f9c40773d7078 to your computer and use it in GitHub Desktop.
http://rusanu.com/2014/02/24/how-to-analyse-sql-server-performance/
White Papers:
Waits and Queues White-Paper (2005) http://technet.microsoft.com/en-us/library/cc966413.aspx
Waits and Queues after 2005 - http://msdn.microsoft.com/en-us/library/ms179984.aspx
sys.dm_exec_requests What is executing right now
sys.dm_os_waiting_tasks Currently waiting tasks
sys.dm_os_wait_stats Aggregated statistics about all wait types
sys.dm_exec_query_stats runtime execution statistics for most queries
sys.dm_exec_sql_text get the text of the query
sys.dm_exec_query_plan get the query execution plan
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment