Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maxsoft
Starting Member
5 Posts |
 Posted - 2013-10-01 : 04:00:32
|
| Hi all,sometimes, I've 95% CPU occupied.Please help me to identify wich is the 'activity' that block system.Thank youMax |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-10-01 : 06:27:01
|
You can start looking at the Activity Monitor in Management Studio.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
maxsoft
Starting Member
5 Posts |
Posted - 2013-10-01 : 06:56:24
|
| Thank you for your reply,what looking for in detail? |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-01 : 09:55:40
|
| Activity monitor shows you the CPU consumption for each of your cores - if it looks like they are spiking, look at the most expensive queries section. It will show you how much CPU each is using (along with other information). Examine those queries to see what they are doing, and why they are taking up the resources. |
|
|
|
maxsoft
Starting Member
5 Posts |
Posted - 2013-10-01 : 10:37:55
|
| well. I 'll try. tyMax |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-10-01 : 12:25:12
|
| In my experience, high CPU is usually due to missing indexes. Run the missing indexes report and compare that to the CPU consumption that James mentioned. Add the appropriate indexes.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
umeandatabase
Starting Member
2 Posts |
Posted - 2013-10-05 : 17:15:25
|
| Can you please check any Database maintenance is running ?..like Update stas/Indexing/Checkdb or Do you found any blocking (Sp_who2)This was my experience recent days.Thanks in AdvanceSree |
|
|
|
markjosol
Starting Member
2 Posts |
Posted - 2013-10-26 : 05:06:11
|
| Run the missing indexes report and compare ________________________________________________http://www.fifautc.com/markjosol josol |
|
|
|
|
|
|
|
|
95% CPU OCCUPIED