CPU usage is high - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

CPU usage is high

Author

Topic

DBA007
Posting Yak Master

145 Posts

Posted - 2010-06-10 : 06:41:11

One of my sqlbox has CPU usage high
SQL Server instance "Dimo" is currently using 90.31% of the CPU.

SQL Server CPU Usage (Percent): Percentage of CPU Time used by the SQL Server instance out of the total on the SQL Server computer.

Any help in how to reduce the CPU usage is Appreciated.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-06-10 : 08:51:25

Optimise the queries using the CPU.

Maybe start with this series - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

--
Gail Shaw
SQL Server MVP

DBA007
Posting Yak Master

145 Posts

Posted - 2010-06-29 : 14:09:39

Thanks Gail,
wow what an Excellent article provided for performance tuning,after reading this iam able to tune storedprocedures,which have high duration,reads,cpu in Production DB
Please,post articles of this type so that people like us can know new things,Thanks once again.

X002548
Not Just a Number

15586 Posts

Posted - 2010-06-29 : 15:03:12

Or..you can read a book, or use google...

Or better yet, have the sprocs tested and logged

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-29 : 16:10:30

quote:
Originally posted by DBA007

Please,post articles of this type so that people like us can know new things,Thanks once again.

A good DBA will subscribe to Gail's blog (and mine too!) so that you are aware of any new articles. You should take some time out of your day weekly or maybe even daily to read SQL Server blogs and articles. This is your responsibility as a technical professional.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

X002548
Not Just a Number

15586 Posts

Posted - 2010-06-29 : 17:03:48

Shamless self promotion...;-)

I LIKE it

quote:
Originally posted by tkizerA good DBA will subscribe to Gail's blog (and mine too!)

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-06-29 : 18:38:45

quote:
Originally posted by DBA007

Thanks Gail,
wow what an Excellent article provided for performance tuning,after reading this iam able to tune storedprocedures,which have high duration,reads,cpu in Production DB

I hate to break it to you, but that's an introductory-level article. There's lots, lots, lots more to performance tuning than what I put in there. Books have been written on the subject (literally)

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources