performance problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » performance problem

performance problem

Rate Topic

Display Mode

Topic Options

Author

Message

ALIF-662928

Posted Wednesday, April 30, 2008 12:44 PM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 10:42 AM
Points: 759, Visits: 613

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

John Rowan

Posted Wednesday, April 30, 2008 12:55 PM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

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

Grant Fritchey

Posted Wednesday, April 30, 2008 1:29 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:51 AM
Points: 13,372, Visits: 25,154

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

RBarryYoung

Posted Wednesday, April 30, 2008 3:03 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

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 »

Permissions