Post reply

Prod Server Down !!! CPU Hike with 8645 error in the error log

  • July 9, 2008 at 6:39 am

    #209670

    Hi All,

    Iam facing High CPU hike issue around 90- 100 % Cpu hike on my SQL Server 2005 64 bit system.

    Environment details :

    SQL Server 2005 version: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Active Passive Cluster enabled

    OS version: Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    Even I see lots of the following error in sql error log:

    2008-07-05 09:01:06.23 spid1434 Error: 8645, Severity: 17, State: 1.

    2008-07-05 09:01:06.23 spid1434 A time out occurred while waiting for memory resources to

    I have taken these action as my next atep to trouble shoot the issue...Please guide me up as this is a Prod server with Active Passive cluster.

    Run the

    select * from sysprocesses.

    System monitor

    SQLServer-Lock Requests/sec

    SQLServer-Memory Manager

    Process-Private bytes

    Process-Working Set bytes

    Memory- Pages/sec

    Process- sqlservr

    Processor- % Processor Time

    SQL Server access - Full Scan / sec

    Network Interface - Bytes Total / sec

    Awating for your comments !!!!!!!!!!!

    "More Green More Oxygen !! Plant a tree today"

  • July 9, 2008 at 6:52 am

    #840068

    So, what did sysprocesses and the perfmon counters show?

    Check this and see if it maybe matches your problem - Memory and SP2[/url]

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 9, 2008 at 12:20 pm

    #840438

    your server could also be under too much parallel activity.


    * Noel

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

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