Post reply

Insufficient memory Error

  • February 13, 2007 at 7:39 am

    #153429

    We are hitting a crippling 701 "insufficient System Memory" error intermittently in out production environment. I haven’t gotten anywhere with PSS in two weeks. The error has occurred 4 times over the past two weeks, crippling our SQL server and application each time. When the error occurs it lasts for 5 to 20 minutes, causing the app to time out, refusing new connections, and a massive slow-down of anything that is running. SQL has recovered on its own two of these times. It recovered following a Kill of hundreds of threads reporting “SEMAPHORE WAIT”. The most recent occurrence nailed all 16 processors at 100%. We were forced to issue shutdown with nowait. I have been monitoring Perfmon very closely; there are no symptoms that precede the error. Each occurrence captures a different query. Any of the queries, when run from Management Studio, complete in under a second.  DBCC MEMORY STATUS reports all memory as being in an unstressed state. The first time the error occurred there were 10 GB still available on the server.

     

    Has anyone else experienced this problem or anything similar? We don’t use linked servers or table valued functions (there are known memory bugs related to each of these items)

     

    The following server and configuration has been running in production for 6 weeks with no issues:

     

    .SQL 2005 EE SP1 Post SP1 Hotfix kb918222

    .Win 2003 SP1 (dedicated box)

    .Quad Dual Core 3GHz

    .32 GB memory

    .AWE enabled

    .No memory related flags in boot.ini

    ."Lock Pages in memory" set for SQL Startup account

    .1 Instance (default)

    .1,994 OLTP databases avg less than 100MB each

    .1,200 active user threads on average (from connection pool of avg 4,000 concurent users)

     

    Any comments would be appraciated

  • February 15, 2007 at 5:26 am

    #689904

    Check this hotfix if it helps

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

    Thanks

    Prasad Bhogadi
    www.inforaise.com

  • February 15, 2007 at 7:06 am

    #689930

    Thanks for the response. That is one of the known bugs we checked out right away. With our situtaion DBCC Memory status shows no signs of any memory pressure anywhere.

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

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