Post reply

Excessive CPU Usage

  • February 2, 2009 at 3:35 am

    #383847

    Hi,

    We are experiencing excessive CPU usage (running at greater than 80%- 100%) on one of an Active/ Active Cluster SQL Server 2000.

    The server is for internal use and was up to last week configured with 2.5Gb memory with a maximum memory of 2.326Gb. It has since been upgraded to 3.8Gb and the max memory adjusted to 3.712Gb.

    The memory upgrade has caused even more excessive CPU usage than before.

    These servers are currently only SP3 - A plan to update to SP4 has been considered. Will this make any difference?

    The other active server is only running at 25%

    Is there any suggestion from the Forum?

    1. Adjust the memory

    2. Update to SP4

    3. Load balance - Move application to other server

  • February 2, 2009 at 7:49 am

    #936431

    At a glance, it appears you are starving the OS of much needed memory. If you have 3.8GB, I (personally) would allocate 2.8 for SQL server and leave 1Gb for the OS. And, I would move to sp4, although I don't believe that's what's causing your issue.

    -- You can't be late until you show up.

  • February 2, 2009 at 7:58 am

    #936444

    Thanks for the reply...

    Would 2.8Gb and 1Gb translate into modifying the SQL Server 2000 memory settings to 2.8Gb max and 1Gb min

  • February 3, 2009 at 9:10 am

    #937231

    Don't change anything for min server memory just change the max server memory to 2.8GB as other poster said.

    MJ

  • February 3, 2009 at 9:36 am

    #937261

    MANU (2/3/2009)

    Don't change anything for min server memory just change the max server memory to 2.8GB as other poster said.

    MJ

    Agreed. Let SQL determine the lower limit, unless you're sure you want the minimum equal to ~x percent. But definitely change the max limit so that it doesn't starve other processes. What, besides SQL, is running on the server?

    -- You can't be late until you show up.

  • February 4, 2009 at 3:58 am

    #937799

    It is a dedicated Server replicating data to another Cluster server.

    The major application hogging the system is a .net sqlclient data provider @ 140k CPU

  • February 4, 2009 at 3:59 am

    #937802

    We have since updated to SP4 but with little effect on the excessive CPU

  • February 4, 2009 at 4:42 am

    #937819

    Is there any advantage in utilising the AWE switch and maximise on 2.8

Viewing 8 posts - 1 through 7 (of 7 total)

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