SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 95% CPU OCCUPIED
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

maxsoft
Starting Member

Italy
5 Posts

Posted - 10/01/2013 :  04:00:32  Show Profile  Reply with Quote
Hi all,
sometimes, I've 95% CPU occupied.
Please help me to identify wich is the 'activity' that block system.

Thank you
Max

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 10/01/2013 :  06:27:01  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You can start looking at the Activity Monitor in Management Studio.



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

maxsoft
Starting Member

Italy
5 Posts

Posted - 10/01/2013 :  06:56:24  Show Profile  Reply with Quote
Thank you for your reply,
what looking for in detail?

Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3704 Posts

Posted - 10/01/2013 :  09:55:40  Show Profile  Reply with Quote
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.
Go to Top of Page

maxsoft
Starting Member

Italy
5 Posts

Posted - 10/01/2013 :  10:37:55  Show Profile  Reply with Quote
well. I 'll try.
ty
Max
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 10/01/2013 :  12:25:12  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

umeandatabase
Starting Member

United Kingdom
2 Posts

Posted - 10/05/2013 :  17:15:25  Show Profile  Reply with Quote
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 Advance
Sree
Go to Top of Page

markjosol
Starting Member

USA
2 Posts

Posted - 10/26/2013 :  05:06:11  Show Profile  Reply with Quote

Run the missing indexes report and compare




________________________________________________
http://www.fifautc.com/

markjosol josol
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000