none
insufficient system memory in resource pool 'default' RRS feed

  • Question

  • Hi,

    i have a server  with 16 GB Memory, 32 bit windows, AWE Enabled, PAE Enabled.

    In this server i have an application working with sql server. i have this event on sql server in the event viewer since last week.

    "There is insufficient system memory in resource pool 'default' to run this query. (Microsoft SQL Server, Error: 701)"

    i changed max memory server to find the problem but it did not help. i changed max memory for query execution and it did not help.

    i checked and double checked awe, pae, priviledge to lock page in server. I enabled resource governor and changed settings for default pool.

    some times when i click on nodes in sql server, the message written above is shown.

    please help me to get over this.


    Regards Ahmad

    Monday, April 23, 2012 4:56 AM

Answers

  • Hi Ahmad,

    The error number 701 indicates the pressure of Stolen Memory. According to the output above, it is not a large number of memory used for stolen for an AWE enabled instance. Are there any tasks with CLR, Linked Server, sp_OACreate, or Extended Stored Procedures, which may consume much more stolen memory than detected by SQL Server? Is there any additional error message on SQL Server error log about ‘failed allocate’?


    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, April 30, 2012 7:25 AM
    Tuesday, April 24, 2012 5:45 AM

All replies

  • Have you stopped and started the default resource governer after the change is made.

    Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

    Monday, April 23, 2012 5:02 AM
  • What MAX memory parameter have you set up?

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Monday, April 23, 2012 5:02 AM
    Answerer
  • Now i have 10000(MB) for max sql server memory. I have restarted server after each change.

    Regards Ahmad

    Monday, April 23, 2012 5:12 AM
  • I also set the -g parameter to 1000 in sql service configuration but the service could not start in timely fashion and I had to remove it.


    Regards Ahmad

    Monday, April 23, 2012 5:31 AM
  • DBCC MemoryStaus will give you hint about which memory clerk is eating memory but it would help if you share errorlog with us to check few more things (like CLR loading and etc.)

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/



    Monday, April 23, 2012 5:53 AM
    Answerer
  • Dear Uri

    here's the result for dbcc memorystatus:

    Memory Manager                           KB
    ---------------------------------------- -----------
    VM Reserved                              1760108
    VM Committed                             97484
    AWE Allocated                            950272
    Reserved Memory                          1024
    Reserved Memory In Use                   0
    Memory node Id = 0                       KB
    ---------------------------------------- -----------
    VM Reserved                              8448
    VM Committed                             8160
    AWE Allocated                            0
    MultiPage Allocator                      6592
    SinglePage Allocator                     89432
    Memory node Id = 1                       KB
    ---------------------------------------- -----------
    VM Reserved                              1748652
    VM Committed                             86480
    AWE Allocated                            950272
    MultiPage Allocator                      16576
    SinglePage Allocator                     89432
    Memory node Id = 32                      KB
    ---------------------------------------- -----------
    VM Reserved                              1920
    VM Committed                             1808
    AWE Allocated                            0
    MultiPage Allocator                      1696
    SinglePage Allocator                     89432
    MEMORYCLERK_SQLGENERAL (node 0)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2144
    MultiPage Allocator                      3512
    MEMORYCLERK_SQLGENERAL (node 1)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     80
    MultiPage Allocator                      0
    MEMORYCLERK_SQLGENERAL (Total)           KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2224
    MultiPage Allocator                      3512
    MEMORYCLERK_SQLBUFFERPOOL (node 0)       KB
    ---------------------------------------- -----------
    VM Reserved                              1517176
    VM Committed                             24984
    AWE Allocated                            950272
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      3104
    MEMORYCLERK_SQLQUERYEXEC (node 0)        KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    MEMORYCLERK_SQLOPTIMIZER (node 0)        KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     456
    MultiPage Allocator                      88
    MEMORYCLERK_SQLUTILITIES (node 0)        KB
    ---------------------------------------- -----------
    VM Reserved                              240
    VM Committed                             240
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     160
    MultiPage Allocator                      0
    MEMORYCLERK_SQLSTORENG (node 0)          KB
    ---------------------------------------- -----------
    VM Reserved                              1984
    VM Committed                             1984
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2656
    MultiPage Allocator                      216
    MEMORYCLERK_SQLSTORENG (node 1)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     432
    MultiPage Allocator                      2856
    MEMORYCLERK_SQLSTORENG (Total)           KB
    ---------------------------------------- -----------
    VM Reserved                              1984
    VM Committed                             1984
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     3088
    MultiPage Allocator                      3072
    MEMORYCLERK_SQLCONNECTIONPOOL (node 0)   KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     248
    MultiPage Allocator                      0
    MEMORYCLERK_SQLCONNECTIONPOOL (node 1)   KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     200
    MultiPage Allocator                      0
    MEMORYCLERK_SQLCONNECTIONPOOL (Total)    KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     448
    MultiPage Allocator                      0
    MEMORYCLERK_SQLCLR (node 0)              KB
    ---------------------------------------- -----------
    VM Reserved                              203520
    VM Committed                             34756
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2712
    MultiPage Allocator                      1752
    MEMORYCLERK_SQLSERVICEBROKER (node 0)    KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     144
    MultiPage Allocator                      344
    MEMORYCLERK_SQLHTTP (node 0)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    MEMORYCLERK_SNI (node 0)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      16
    MEMORYCLERK_SNI (node 1)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      16
    MEMORYCLERK_SNI (node 32)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      16
    MEMORYCLERK_SNI (Total)                  KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     32
    MultiPage Allocator                      48
    MEMORYCLERK_FULLTEXT (node 0)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     24
    MultiPage Allocator                      0
    MEMORYCLERK_SQLXP (node 0)               KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      0
    MEMORYCLERK_XE_BUFFER (node 0)           KB
    ---------------------------------------- -----------
    VM Reserved                              2816
    VM Committed                             2816
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      0
    MEMORYCLERK_XE_BUFFER (node 1)           KB
    ---------------------------------------- -----------
    VM Reserved                              1408
    VM Committed                             1408
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      0
    MEMORYCLERK_XE_BUFFER (Total)            KB
    ---------------------------------------- -----------
    VM Reserved                              4224
    VM Committed                             4224
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      0
    MEMORYCLERK_HOST (node 1)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     232
    MultiPage Allocator                      176
    MEMORYCLERK_SOSNODE (node 0)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     7912
    MultiPage Allocator                      6720
    MEMORYCLERK_SOSNODE (node 1)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     7336
    MultiPage Allocator                      3336
    MEMORYCLERK_SOSNODE (node 32)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      1616
    MEMORYCLERK_SOSNODE (Total)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     15264
    MultiPage Allocator                      11672
    MEMORYCLERK_FULLTEXT_SHMEM (node 0)      KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              576
    SM Committed                             576
    SinglePage Allocator                     0
    MultiPage Allocator                      0
    MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
    ---------------------------------------------- -----------
    VM Reserved                                    0
    VM Committed                                   0
    AWE Allocated                                  0
    SM Reserved                                    0
    SM Committed                                   0
    SinglePage Allocator                           32
    MultiPage Allocator                            0
    MEMORYCLERK_XE (node 0)                  KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     56
    MultiPage Allocator                      96
    CACHESTORE_OBJCP (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     4696
    MultiPage Allocator                      176
    CACHESTORE_SQLCP (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     15392
    MultiPage Allocator                      440
    CACHESTORE_PHDR (node 0)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8536
    MultiPage Allocator                      16
    CACHESTORE_XPROC (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     24
    MultiPage Allocator                      0
    CACHESTORE_TEMPTABLES (node 0)           KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      0
    CACHESTORE_NOTIF (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      0
    CACHESTORE_VIEWDEFINITIONS (node 0)      KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      0
    CACHESTORE_XMLDBTYPE (node 0)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_XMLDBELEMENT (node 0)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_XMLDBATTRIBUTE (node 0)       KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_STACKFRAMES (node 0)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      8
    CACHESTORE_STACKFRAMES (node 1)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      8
    CACHESTORE_STACKFRAMES (node 32)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      8
    CACHESTORE_STACKFRAMES (Total)           KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      24
    CACHESTORE_BROKERTBLACS (node 0)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     24
    MultiPage Allocator                      0
    CACHESTORE_BROKERTBLACS (node 1)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     24
    MultiPage Allocator                      0
    CACHESTORE_BROKERTBLACS (Total)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     48
    MultiPage Allocator                      0
    CACHESTORE_BROKERKEK (node 0)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_BROKERDSH (node 0)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_BROKERRSB (node 0)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_BROKERREADONLY (node 0)       KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     32
    MultiPage Allocator                      0
    CACHESTORE_BROKERTO (node 0)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_EVENTS (node 0)               KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      0
    CACHESTORE_CLRPROC (node 0)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    CACHESTORE_SYSTEMROWSET (node 0)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     632
    MultiPage Allocator                      0
    CACHESTORE_SYSTEMROWSET (node 1)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     160
    MultiPage Allocator                      0
    CACHESTORE_SYSTEMROWSET (Total)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     792
    MultiPage Allocator                      0
    CACHESTORE_CONVPRI (node 0)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     32
    MultiPage Allocator                      0
    CACHESTORE_CONVPRI (node 1)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     16
    MultiPage Allocator                      0
    CACHESTORE_CONVPRI (Total)               KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     48
    MultiPage Allocator                      0
    CACHESTORE_FULLTEXTSTOPLIST (node 0)     KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     32
    MultiPage Allocator                      0
    USERSTORE_SCHEMAMGR (node 0)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     7984
    MultiPage Allocator                      32
    USERSTORE_DBMETADATA (node 0)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     896
    MultiPage Allocator                      0
    USERSTORE_DBMETADATA (node 1)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     40
    MultiPage Allocator                      0
    USERSTORE_DBMETADATA (Total)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     936
    MultiPage Allocator                      0
    USERSTORE_TOKENPERM (node 0)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     424
    MultiPage Allocator                      0
    USERSTORE_TOKENPERM (node 1)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     200
    MultiPage Allocator                      0
    USERSTORE_TOKENPERM (Total)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     624
    MultiPage Allocator                      0
    USERSTORE_OBJPERM (node 0)               KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     3336
    MultiPage Allocator                      0
    USERSTORE_OBJPERM (node 1)               KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     400
    MultiPage Allocator                      0
    USERSTORE_OBJPERM (Total)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     3736
    MultiPage Allocator                      0
    USERSTORE_SXC (node 0)                   KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     48
    MultiPage Allocator                      0
    USERSTORE_SXC (node 1)                   KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     64
    MultiPage Allocator                      0
    USERSTORE_SXC (node 32)                  KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    USERSTORE_SXC (Total)                    KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     120
    MultiPage Allocator                      0
    OBJECTSTORE_LBSS (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     248
    MultiPage Allocator                      0
    OBJECTSTORE_LBSS (node 1)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     240
    MultiPage Allocator                      0
    OBJECTSTORE_LBSS (Total)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     488
    MultiPage Allocator                      0
    OBJECTSTORE_SNI_PACKET (node 0)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     264
    MultiPage Allocator                      56
    OBJECTSTORE_SNI_PACKET (node 1)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     320
    MultiPage Allocator                      56
    OBJECTSTORE_SNI_PACKET (node 32)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      56
    OBJECTSTORE_SNI_PACKET (Total)           KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     584
    MultiPage Allocator                      168
    OBJECTSTORE_SERVICE_BROKER (node 0)      KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     400
    MultiPage Allocator                      0
    OBJECTSTORE_LOCK_MANAGER (node 0)        KB
    ---------------------------------------- -----------
    VM Reserved                              4100
    VM Committed                             4100
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     18688
    MultiPage Allocator                      0
    OBJECTSTORE_LOCK_MANAGER (node 1)        KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     1184
    MultiPage Allocator                      0
    OBJECTSTORE_LOCK_MANAGER (node 32)       KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     24
    MultiPage Allocator                      0
    OBJECTSTORE_LOCK_MANAGER (Total)         KB
    ---------------------------------------- -----------
    VM Reserved                              4100
    VM Committed                             4100
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     19896
    MultiPage Allocator                      0
    OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
    ------------------------------------------ -----------
    VM Reserved                                0
    VM Committed                               0
    AWE Allocated                              0
    SM Reserved                                0
    SM Committed                               0
    SinglePage Allocator                       16
    MultiPage Allocator                        0
    Buffer Pool                              Value
    ---------------------------------------- -----------
    Committed                                118368
    Target                                   1280000
    Database                                 65118
    Dirty                                    1594
    In IO                                    0
    Latched                                  0
    Free                                     42071
    Stolen                                   11179
    Reserved                                 0
    Visible                                  172032
    Stolen Potential                         152251
    Limiting Factor                          10
    Last OOM Factor                          0
    Page Life Expectancy                     3461
    Process/System Counts                    Value
    ---------------------------------------- --------------------
    Available Physical Memory                13570449408
    Available Virtual Memory                 37429248
    Available Paging File                    28976893952
    Working Set                              157011968
    Percent of Committed Memory in WS        100
    Page Faults                              60222
    System physical memory high              1
    System physical memory low               0
    Process physical memory low              0
    Process virtual memory low               0
    Procedure Cache                          Value
    ---------------------------------------- -----------
    TotalProcs                               167
    TotalPages                               3660
    InUsePages                               64
    Global Memory Objects                    Pages
    ---------------------------------------- -----------
    Resource                                 219
    Locks                                    2487
    XDES                                     163
    SETLS                                    24
    SE Dataset Allocators                    48
    SubpDesc Allocators                      24
    SE SchemaManager                         781
    SE Column Metadata Cache                 220
    SQLCache                                 89
    Replication                              2
    ServerGlobal                             26
    XP Global                                2
    SortTables                               2
    Query Memory Objects (internal)          Value
    ---------------------------------------- -----------
    Grants                                   0
    Waiting                                  0
    Available                                122807
    Current Max                              122807
    Future Max                               122807
    Physical Max                             122807
    Next Request                             0
    Waiting For                              0
    Cost                                     0
    Timeout                                  0
    Wait Time                                0
    Small Query Memory Objects (internal)    Value
    ---------------------------------------- -----------
    Grants                                   0
    Waiting                                  0
    Available                                6463
    Current Max                              6463
    Future Max                               6463
    Query Memory Objects (default)           Value
    ---------------------------------------- -----------
    Grants                                   0
    Waiting                                  0
    Available                                122807
    Current Max                              122807
    Future Max                               122807
    Physical Max                             122807
    Next Request                             0
    Waiting For                              0
    Cost                                     0
    Timeout                                  0
    Wait Time                                0
    Small Query Memory Objects (default)     Value
    ---------------------------------------- -----------
    Grants                                   0
    Waiting                                  0
    Available                                6463
    Current Max                              6463
    Future Max                               6463
    Optimization Queue (internal)            Value
    ---------------------------------------- -----------
    Overall Memory                           1129627648
    Target Memory                            1129627648
    Last Notification                        1
    Timeout                                  6
    Early Termination Factor                 5
    Small Gateway (internal)                 Value
    ---------------------------------------- -----------
    Configured Units                         32
    Available Units                          32
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         250000
    Threshold                                250000
    Medium Gateway (internal)                Value
    ---------------------------------------- -----------
    Configured Units                         8
    Available Units                          8
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         12
    Threshold                                -1
    Big Gateway (internal)                   Value
    ---------------------------------------- -----------
    Configured Units                         1
    Available Units                          1
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         8
    Threshold                                -1
    Optimization Queue (default)             Value
    ---------------------------------------- -----------
    Overall Memory                           1129627648
    Target Memory                            1129627648
    Last Notification                        1
    Timeout                                  6
    Early Termination Factor                 5
    Small Gateway (default)                  Value
    ---------------------------------------- -----------
    Configured Units                         32
    Available Units                          32
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         250000
    Threshold                                250000
    Medium Gateway (default)                 Value
    ---------------------------------------- -----------
    Configured Units                         8
    Available Units                          8
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         12
    Threshold                                -1
    Big Gateway (default)                    Value
    ---------------------------------------- -----------
    Configured Units                         1
    Available Units                          1
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         8
    Threshold                                -1
    Memory Pool Manager                      Pages
    ---------------------------------------- -----------
    Reserved Current                         0
    Reserved Limit                           152255
    Memory Pool (internal)                   Pages
    ---------------------------------------- -----------
    Allocations                              2206
    Predicted                                2206
    Private Target                           0
    Private Limit                            0
    Total Target                             163430
    Total Limit                              163430
    OOM Count                                0
    MEMORYBROKER_FOR_CACHE (internal)        Pages
    ---------------------------------------- -----------
    Allocations                              1058
    Rate                                     0
    Target Allocations                       137894
    Future Allocations                       0
    Overall                                  137894
    Last Notification                        1
    MEMORYBROKER_FOR_STEAL (internal)        Pages
    ---------------------------------------- -----------
    Allocations                              1148
    Rate                                     0
    Target Allocations                       137894
    Future Allocations                       0
    Overall                                  137894
    Last Notification                        1
    MEMORYBROKER_FOR_RESERVE (internal)      Pages
    ---------------------------------------- -----------
    Allocations                              0
    Rate                                     0
    Target Allocations                       137894
    Future Allocations                       0
    Overall                                  137894
    Last Notification                        1
    Memory Pool (default)                    Pages
    ---------------------------------------- -----------
    Allocations                              8969
    Predicted                                8989
    Private Target                           0
    Private Limit                            0
    Total Target                             163430
    Total Limit                              163430
    OOM Count                                0
    MEMORYBROKER_FOR_CACHE (default)         Pages
    ---------------------------------------- -----------
    Allocations                              7004
    Rate                                     20
    Target Allocations                       137894
    Future Allocations                       0
    Overall                                  137894
    Last Notification                        1
    MEMORYBROKER_FOR_STEAL (default)         Pages
    ---------------------------------------- -----------
    Allocations                              1965
    Rate                                     0
    Target Allocations                       137894
    Future Allocations                       0
    Overall                                  137894
    Last Notification                        1
    MEMORYBROKER_FOR_RESERVE (default)       Pages
    ---------------------------------------- -----------
    Allocations                              0
    Rate                                     -9
    Target Allocations                       137894
    Future Allocations                       0
    Overall                                  137894
    Last Notification                        1

    and about errorlog you've mentioned, which log and from where i can share with you.


    Regards Ahmad

    Monday, April 23, 2012 6:33 AM
  • Hi Ahmad,

    The error number 701 indicates the pressure of Stolen Memory. According to the output above, it is not a large number of memory used for stolen for an AWE enabled instance. Are there any tasks with CLR, Linked Server, sp_OACreate, or Extended Stored Procedures, which may consume much more stolen memory than detected by SQL Server? Is there any additional error message on SQL Server error log about ‘failed allocate’?


    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, April 30, 2012 7:25 AM
    Tuesday, April 24, 2012 5:45 AM
  • As stephanie mentioned, we will need to have SQL error logs of the time of the issue to have more clarity. 

    you could run the command xp_readerrorlog 0,1,'logging' in query analyzer and you will find the SQL error log location. Pick up the file of the time when the issue occured and share snippet.

    Also, you may want to check this blog: - http://troubleshootingsql.com/2009/12/30/how-to-find-the-largest-free-block-in-the-mtl/

    HTH!


    Kind regards| Harsh Chawla | Personal Blog:- SQL-blogs
    |Team Blog:- Team Blog

    Tuesday, April 24, 2012 3:45 PM