Post reply

The server was unable to allocate from the system paged pool because the pool was empty.

  • March 30, 2012 at 6:58 am

    #253355

    I have run into a problem with memory. I have a 32 bit SQL 2005 Enterprise edition clustered with 2 modes. Since last 2 weeks the active node crashes out every 48 hours.

    Some of the errors I am getting are:

    1. The server was unable to allocate from the system paged pool because the pool was empty.

    Event ID: 2020, Source: Srv

    This message is always preceded by

    Not enough resources are available to complete this operation.

    Event ID's: (1219,1508,1505)

    We have researched patches that went out to these server, but nothing that could lead us to why this is happening.

    Nothing else have changed, Same code is running against this DB server, no new DB objects created.

    Thanks

  • March 30, 2012 at 7:07 am

    #1466915

    What's SQL's memory settings? How much memory on the server?

    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

  • March 30, 2012 at 7:16 am

    #1466922

    Its 10GB total, assigned for SQL 6.5GB.

    Total as of now is:

    Total available: 10GB

    Used: 7.4

    Free 2.6

    Thanks

  • March 30, 2012 at 7:47 am

    #1466939

    AWE? /PAE? /3GB?

    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

  • March 30, 2012 at 8:04 am

    #1466953

    Server PAE, SQL AWE.

  • March 30, 2012 at 8:15 am

    #1466958

    Have you gone through these?

    http://support.microsoft.com/kb/822219

    http://support.microsoft.com/kb/312362

    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

Viewing 6 posts - 1 through 6 (of 6 total)

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