#sys.dm_exec_query_plan

SQL Server – Disk Usage Monitoring

[bs url=http://social.technet.microsoft.com/wiki/contents/articles/3214.monitoring-disk-usage.aspx] (more…)

[bs url=http://www.codeproject.com/Articles/579593/How-to-Find-the-Top-Most-Expens] sys.dm_exec_query_stats DMV (Dynamic Management View) is described at http://msdn.microsoft.com/en-us/library/ms189741.aspx

Top 10 Total CPU Consuming Queries

SELECT TOP 10 QT.TEXT AS STATEMENT_TEXT, QP.QUERY_PLAN, QS.TOTAL_WORKER_TIME AS CPU_TIME FROM SYS.DM_EXEC_QUERY_STATS QS CROSS APPLY SYS.DM_EXEC_SQL_TEXT…

SQL Server – most costly queries in terms of Total CPU

[bs url=http://www.johnsansom.com/how-to-identify-the-most-costly-sql-server-queries-using-dmvs/]

SELECT TOP 20 qs.sql_handle, qs.execution_count, qs.total_worker_time AS Total_CPU, total_CPU_inSeconds = --Converted from microseconds qs.total_worker_time/1000000, average_CPU_inSeconds = --Converted from microseconds (qs.total_worker_time/1000000) / qs.execution_count, qs.total_elapsed_time,…