CPU Usage Report to show what sql is doing - by Wim SQL Server

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 767023 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/11/2012 3:23:30 AM
Access Restriction Public


I 'm looking for a cpu report that shows how many of the cpu time used by sql is used for:
-handling connections
-queries : compiling, parallel, hashes
-db compression
- ...

TO get a better insight what parts of sql use the cpu.. 

We have an application that creates connections all the time and I would like to see how many * of cpu time used by sql is spend on this and compiling queries, ...
Sign in to post a comment.
Posted by Guy [MSFT] on 3/1/2013 at 8:02 AM
Hello. Thanks for logging this Connect item.

In this case the recommendation is to use the SQL Server Performance Dashboard Reports (http://www.microsoft.com/en-us/download/details.aspx?id=29063) or do custom queries on DMVs such as sys.dm_exec_query_stats, sys.dm_os_wait_stats and perfmon counters - for an example see http://msdn.microsoft.com/en-us/magazine/cc135978.aspx or http://msdn.microsoft.com/en-us/magazine/cc135978.aspx.

Guy Bowerman - SQL Server engine team.