SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


performance problem


performance problem

Author
Message
ALIF-662928
ALIF-662928
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1217 Visits: 764
Hi,
I have problem with my production server, the cpu usage goes to 100% 4-5 times everyday, which is very critical for us. i have taken few counters for a period of 24hrs. can any1 suggest me about the performance issue by looking this statistics.
Thanks




COMPUTER NameTongueroduction Average Minimum Maximum
Memory: Pages/sec 324.740 0.000 4762.910
Physical Disk: % Disk time 160.716 0.183 5275.256
Physical Disk: Avg. Disk Queue Length 8.036 0.009 263.763
Processor: % Processor Time 24.867 4.363 100.000
System: Processor Queue Length 0 0 26
SQL Server Buffer: Buffer Cache Hit Ratio99.698 76.514 99.893
SQL Server General: User Connections 34 21 66
SQL Server General:Transactions 2 0 23
SQL Server General:Logins/sec 0.133 0 12.111
John Rowan
John Rowan
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7614 Visits: 4560
Your average CPU time looks good. When your CPU usage goes up to 100%, how long does it stay there for? If you are just seeing spikes up to 100 and then dropping back down right away, this is normal behavior. If you are seeing sustained 100% usage, you've got a problem. Are you seeing poor performance from the application during these high CPU periods?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54626 Visits: 32776
Have you run a trace to capture the calls coming in to the server? Even if you identify a CPU problem, you need to figure out what's causing the problem.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
RBarryYoung
RBarryYoung
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19034 Visits: 9518
Also, you need to give us some configuration information. The significance of these numbers is heavily affected by how many processors*cores and how many volumes/spindles.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search