Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Yesterday @ 11:07 AM
Points: 2,015, Visits: 3,810
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: Monday, November 21, 2016 9:50 AM
Points: 863, Visits: 1,318
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 @ 4:14 PM
Points: 7,933, Visits: 14,358
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