performance problem

• ALIF-662928

  SSCertifiable

  Points: 6054

  More actions

  April 30, 2008 at 12:44 pm

  #185030

  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.7400.0004762.910

  Physical Disk: % Disk time 160.7160.1835275.256

  Physical Disk: Avg. Disk Queue Length 8.0360.009263.763

  Processor: % Processor Time 24.8674.363100.000

  System: Processor Queue Length 0026

  SQL Server Buffer: Buffer Cache Hit Ratio99.698 76.51499.893

  SQL Server General: User Connections 342166

  SQL Server General:Transactions2023

  SQL Server General:Logins/sec0.133012.111

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  April 30, 2008 at 12:55 pm

  #809261

  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[/url] - by Jeff Moden

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  April 30, 2008 at 1:29 pm

  #809290

  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

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  April 30, 2008 at 3:03 pm

  #809330

  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.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]