Interpret a DMV to fimd Performance Bottleneck
Posted on 2011-10-20
I have a Performance issue and ran a DMV: I obtaned the following DMV in a SQL 2005 Administration book "The Bible"
select plan_handle, SUM(total_worker_time) as total_cpu_time, Sum(execution_count) as total_execution_count,
Count(*) as number_of_statmetns
From sys.dm_exec_query_stats as QueryStats
Group By plan_handle
Order By sum(total_worker_time) desc
I received output but I do not know how to interpret it. The column plan_handle looks to be a hexidecimal #, but how am I to find which query in my many databases is the culpret?