cpu utlization

Question

cpu utlization

SAT_SQL

Default port

Points: 1465
More actions
June 29, 2009 at 11:37 pm

#207693

HI all
We have the problem , when 5 of us using the same local server called "sw-19", we the utlization of sqlserver is becoming to 70% , as per the policies it should not be exceed more than 40%, can u please suggest what can i do for this.
2) when ever we run the query for exampel typical query it will reaches to 70% why can u please give the detail explaniation,
3) please suggest some study links for me in this issue .
Regards
sat_sql

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

We really can't help you based on the extremely vague description of your problem/issue.

If this is a performance problem, please read the second article I have referenced below in my signature block regarding help with performance issues. Follow the instructions in that article regarding what you need to post.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

SAT_SQL (6/29/2009)
We have the problem , when 5 of us using the same local server called "sw-19", we the utlization of sqlserver is becoming to 70% , as per the policies it should not be exceed more than 40%, can u please suggest what can i do for this.

Either change your policies or tune the queries that are causing the excessive CPU use.

2) when ever we run the query for exampel typical query it will reaches to 70%

There's no such thing as a 'typical query'

can u please give the detail explaniation,

Either the query is inefficient or the indexes are poor, or both. Seriously, I can't tell you any more than that from the little information that you've given.

3) please suggest some study links for me in this issue .

http://www.amazon.com/Inside-Microsoft%C2%AE-SQL-Server-2005/dp/0735621969/ref=sr_1_1?ie=UTF8&qid=1246392686&sr=1-1

http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_2?ie=UTF8&s=books&qid=1246392770&sr=1-2

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

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Performance tuning is neither a simple nor a brief topic.

If you've got serious problems (and it sounds like you have) I would suggest you hire a skilled consultant to look at things for you. They'll be able to get to the bottom of things faster than you will if you're new to performance tuning and they can train you at the same time.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass