Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

performance problem Expand / Collapse
Author
Message
Posted Wednesday, April 30, 2008 12:44 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 10:03 AM
Points: 759, Visits: 642
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 Name:Production 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
Post #493192
Posted Wednesday, April 30, 2008 12:55 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:01 AM
Points: 3,844, Visits: 3,841
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
Post #493201
Posted Wednesday, April 30, 2008 1:29 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:15 AM
Points: 15,622, Visits: 28,006
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #493235
Posted Wednesday, April 30, 2008 3:03 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
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."
Post #493285
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse