Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

CPU on SQL server Expand / Collapse
Posted Monday, April 15, 2013 10:25 AM


Group: General Forum Members
Last Login: Friday, November 20, 2015 12:04 PM
Points: 1,871, Visits: 3,520
Our .net application runs slow from a couple of weeks ago, it is using the SQL database, I see the CPU usage on SQL server sometimes goes up to 96% above, how can I troubleshooting this to see what is using the CPU?

Post #1442396
Posted Tuesday, April 16, 2013 1:59 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 25, 2015 1:52 PM
Points: 859, Visits: 1,280
Use Activity monitor to see what is going on when you see CPU jumped to 96%.

Also I would recommend using Adam Machanic sp_whoisactive, to see what is going on.

You can download code from here.
Post #1442995
Posted Tuesday, April 23, 2013 6:59 AM



Group: General Forum Members
Last Login: Today @ 2:50 PM
Points: 7,294, Visits: 13,155
sp_WhoIsActive is a great tool for seeing what is happening at a particular moment. You can also have it capture its results to a table and schedule it which is nice. Glenn Berry has some great diagnostic queries that inspect the plan cache to show you which queries in a particular database have used the most CPU, I/O, memory, etc. They are great for finding those problem queries.

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1445398
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse