Home Dashboard Directory Help
Search

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


Status: 

Resolved
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Suggestion
ID: 767023
Opened: 10/11/2012 3:23:30 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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, ...
Details
Sign in to post a comment.
Posted by Microsoft 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.

Regards
Guy Bowerman - SQL Server engine team.
Sign in to post a workaround.