Question 1: What exactly is the plan_handle? It doesn't appear to be a hash of the plan, like it is in Oracle. Sum(qs.execution_count) as total_execution_count,Ĭross apply sys.dm_exec_sql_text(qs.plan_handle) as st Sum(qs.total_worker_time) as total_cpu_time, Another SQL server question: I have a simple query that gives me the most CPU intensive SQL since the counters were reset: select top 10
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |