performance problem

  • 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

  • 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

  • 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

  • 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]

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

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