locked
SQL Server Memory Problem RRS feed

  • Question

  • One of my SQL Server 2005 database servers has recently started returning "There is insufficient system memory to run this query" at random.  Each time this has happened, I've checked the server, and there is always at least a gig of physical memory free, and SQL Server is using less than 1 gig of memory.  Whenever the database server returns this error, it also writes the following error message to the SQL Server logs: "Error: 701, Severity: 17, State: 13.".  I've searched online, but I can't find anything about this specific error message.  I tried some of the solutions that people had posted to other "Error: 701, Severity: 17..." errors, but none of them have made any difference.  This database server is running SQL Server 2005 SP2.

    Anyone have any suggestions?
    Tuesday, April 3, 2007 9:13 PM

All replies

  • I think it is VAS(memtoleave) issue...

    Is SQL Server 32 bit?

     

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19498

    http://blogs.msdn.com/slavao/archive/2006/08/03/687573.aspx

     

    FIX: Error message when you run an application against SQL Server 2005 that uses many unique user logins or performs many user login impersonations: "insufficient system memory to run this query"

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

     

    There may not be enough virtual memory when you have a large number of databases in SQL Server

    http://support.microsoft.com/kb/316749
    Wednesday, April 4, 2007 5:32 AM
  • Can you please share the output of 'dbcc memorystatus' when the problem occurs?

     

    Thanks, Ron D.

    Thursday, April 5, 2007 2:32 PM
  • I started receiving this error today...I am using Service Broker. 

    Memory Manager     KB
    VM Reserved    1667652
    VM Committed    1666708
    AWE Allocated    0
    Reserved Memory    1024
    Reserved Memory In Use    0
    ------------------
    MEMORYCLERK_SQLGENERAL (Total)     KB
     VM Reserved    0
     VM Committed    0
     AWE Allocated    0
     SM Reserved     0
     SM Commited     0
     SinglePage Allocator     4728
     MultiPage Allocator     3088
    ---------------------
    MEMORYCLERK_SQLBUFFERPOOL (Total)     KB
     VM Reserved    1638476
     VM Committed    1638476
     AWE Allocated    0
     SM Reserved     0
     SM Commited     0
     SinglePage Allocator     0
     MultiPage Allocator     400
    -----------------------------
    Buffer Distribution    Buffers
    Stolen    3830
    Free    330
    Cached    130035
    Database (clean)    66093
    Database (dirty)    2506
    I/O    1
    Latched    5
    --------------------------------
    Buffer Counts    Buffers
    Committed    202800
    Target    202800
    Hashed    68606
    Stolen Potential    58797
    External Reservation    0
    Min Free    256
    Visible    202800
    Available Paging File    547107

    Tuesday, April 24, 2007 2:56 PM