none
here is insufficient system memory in resource pool 'internal' to run this query RRS feed

  • Question

  • We are facing the  issue in Microsoft SQL Server 2008 R2 DataCenter Edition 32 bit  "There is insufficient system memory in resource pool 'internal' to run this query" and server not respond.when we restart the server it is working fine.

    Os : windows 2008 enterprise edition
    Sal Server : Microsoft SQL Server 2008 R2 DataCenter Edition 32 bit 
    SErvice Pack 2


    Monday, December 14, 2015 5:18 AM

All replies

  • I am not sure that this link could help you but , up to now , it is the only one which seems to concern you.

    Be careful , it is related to a fix which should have been included in the last service pack provided for your SQL Server 2008 R2.

    An useful information could be the last installed service pack.

    Also , are you using full-text search ? If not , I will go on my research.

    We are waiting for your feedback to try to help you more efficiently.

    Have a nice day. 


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Monday, December 14, 2015 11:10 AM
    Moderator
  • Hi 0xc004f074 ,

    I am sorry but I have discovered that I have not read your initial post in a full enough way ( you have a 32-bit edition ).

    So I would suggest to have a look at this link :

    http://dba.stackexchange.com/questions/12394/sql-server-2008-r2-there-is-insufficient-system-memory-in-resource-pool-default

    I think that this link could help you.

    Have a nice day.


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Monday, December 14, 2015 11:53 AM
    Moderator
  • We are facing the  issue in Microsoft SQL Server 2008 R2 DataCenter Edition 32 bit  "There is insufficient system memory in resource pool 'internal' to run this query" and server not respond.when we restart the server it is working fine.

    Os : windows 2008 enterprise edition
    Sal Server : Microsoft SQL Server 2008 R2 DataCenter Edition 32 bit 
    SErvice Pack 2

    With 32 bit you are bound to get into issues of OOM. Any chance you are planning to upgrade to 64 bit.

    Belive me that would be best solution.

    So when you are getting this OOM error, what command were you running. Please post output of

    select @@Version
    go
    select * from sys.dm_os_process_memory
    Please share errolog here. I need lot of information to actually tell you what could be the issue


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    Monday, December 14, 2015 2:10 PM
  • we restart the server .
    Tuesday, December 15, 2015 5:06 AM
  • we are facing issue in Microsoft SQL Server 2008 R2 DataCenter Edition x86. which is installed on Windows server 2008 enterprise 32 bit system with 32 GB ram.below find the error.
      There is insufficient system memory in resource pool 'internal' to run this query. Error: 701, 
    Tuesday, December 15, 2015 5:07 AM
  • we are using  full-text search 
    Tuesday, December 15, 2015 5:09 AM
  • we are facing issue in Microsoft SQL Server 2008 R2 DataCenter Edition x86. which is installed on Windows server 2008 enterprise 32 bit system with 32 GB ram.below find the error.
      There is insufficient system memory in resource pool 'internal' to run this query. Error: 701, 

    Tuesday, December 15, 2015 5:10 AM
  • The client was unable to reuse a session with SPID 300, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
    Tuesday, December 15, 2015 1:06 PM
  • You wrote "The client was unable to reuse a session with SPID 300, which had been reset for connection pooling". Usually , the timespan to reuse a connection is 120 seconds before to throw an error. I have seen a similar error in another question in a SQL Server Forum ( possibly SMO 120 seconds is a default value for a SqlClient object  ).

    Please , could you explain which is the type of application throwing this error ? ( written with .Net Framework or a simple execution of a script in SSMS .... )

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Tuesday, December 15, 2015 4:53 PM
    Moderator
  • My first observation is that you're using a 32 bit Version of SQL Server 2008; what is the Bit Version of the operating system?  If this is 64 bit then you are going to have other issues such as issues with performance counters.

    Instead of restarting SQL Server you could purge and shrink tempdb; this approach is less drastic and eliminates downtime: -

    Use tempDB
    GO
    CHECKPOINT;
    GO
    DBCC DROPCLEANBUFFERS;
    GO
    DBCC FREEPROCCACHE;
    GO
    DBCC FREESYSTEMCACHE ('ALL');
    GO
    DBCC FREESYSTEMCACHE ('ALL');
    GO
    DBCC SHRINKFILE (TEMPDEV, 100);   --- New file size in MB
    GO
    DBCC SHRINKFILE (TEMPLOG, 100);   --- New file size in MB
    GO

    How often are you rebuilding the Full Text Catalogs?  They could be getting out of sync with the actual data and this can be another performance hit.


    Please click "Mark As Answer" if my post helped. Tony C.

    Tuesday, December 15, 2015 5:30 PM
  • written with .Net Framework 
    Wednesday, December 16, 2015 6:52 AM
  • You are just posting without reading anything which others are posting. I asked you about some output and you did not posted it what is point of asking the help.

    Nobody can give you solution immediately for OOM error. If you can post it well and good if not there is no point in further discussion


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    Wednesday, December 16, 2015 7:16 AM
  • Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (Intel X86)   Mar 19 2015 13:34:46   Copyright (c) Microsoft Corporation  Data Center Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)

    Output of sys.dm_os_process_memory query
    physical_memory_in_use_kb large_page_allocations_kb locked_page_allocations_kb total_virtual_address_space_kb virtual_address_space_reserved_kb virtual_address_space_committed_kb virtual_address_space_available_kb page_fault_count memory_utilization_percentage available_commit_limit_kb process_physical_memory_low process_virtual_memory_low
    4590712 0 4415488 2097024 1588916 1268484 508108 354127 100 88353460 0 0
    Wednesday, December 16, 2015 7:31 AM
  • Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (Intel X86)   Mar 19 2015 13:34:46   Copyright (c) Microsoft Corporation  Data Center Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)

     

    Output of sys.dm_os_process_memory query

    physical_memory_in_use_kb

    large_page_allocations_kb

    locked_page_allocations_kb

    total_virtual_address_space_kb

    virtual_address_space_reserved_kb

    virtual_address_space_committed_kb

    virtual_address_space_available_kb

    page_fault_count

    memory_utilization_percentage

    available_commit_limit_kb

    process_physical_memory_low

    process_virtual_memory_low

    4590712

    0

    4415488

    2097024

    1588916

    1268484

    508108

    354127

    100

    88353460

    0

    0

    Wednesday, December 16, 2015 7:31 AM
  • Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (Intel X86)   Mar 19 2015 13:34:46   Copyright (c) Microsoft Corporation  Data Center Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)

    Output of sys.dm_os_process_memory query

    physical_memory_in_use_kb

    large_page_allocations_kb

    locked_page_allocations_kb

    total_virtual_address_space_kb

    virtual_address_space_reserved_kb

    virtual_address_space_committed_kb

    virtual_address_space_available_kb

    page_fault_count

    memory_utilization_percentage

    available_commit_limit_kb

    process_physical_memory_low

    process_virtual_memory_low

    4590712

    0

    4415488

    2097024

    1588916

    1268484

    508108

    354127

    100

    88353460

    0

    0

    Thanks for the output. SQL Server is using 4.3 G and AWE used memory is approx 4.2 G. I am not sure whether PAE is enabled on system or not but can you check whether PAE is enabled

    If PAE is enabled it will allow OS to see more than 4 G of memory so as you said server has 32 G of RAM so OS should have capapbility to see more than 4 G.

    Now can you tell me what were you running when you go OOM error. Can you also share with us Errorlog and output of DBCC MEMOERYSTATUS. PLease share it on any shared drive like Dropbox , onedrive.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    • Marked as answer by 0xc004f074 Friday, December 18, 2015 12:20 PM
    • Unmarked as answer by 0xc004f074 Friday, December 18, 2015 12:20 PM
    • Marked as answer by 0xc004f074 Friday, December 18, 2015 12:20 PM
    • Unmarked as answer by 0xc004f074 Friday, December 18, 2015 12:20 PM
    Wednesday, December 16, 2015 7:48 AM
  • DBCC memorystatus output...
    
    Memory Manager                           KB
    ---------------------------------------- -----------
    VM Reserved                              1406624
    VM Committed                             149044
    AWE Allocated                            5414912
    Reserved Memory                          1024
    Reserved Memory In Use                   0
    
    (5 row(s) affected)
    
    Memory node Id = 0                       KB
    ---------------------------------------- -----------
    VM Reserved                              7488
    VM Committed                             7312
    AWE Allocated                            0
    MultiPage Allocator                      5664
    SinglePage Allocator                     605944
    
    (5 row(s) affected)
    
    Memory node Id = 1                       KB
    ---------------------------------------- -----------
    VM Reserved                              1396320
    VM Committed                             139024
    AWE Allocated                            5414912
    MultiPage Allocator                      41168
    SinglePage Allocator                     605944
    
    (5 row(s) affected)
    
    Memory node Id = 32                      KB
    ---------------------------------------- -----------
    VM Reserved                              1728
    VM Committed                             1672
    AWE Allocated                            0
    MultiPage Allocator                      1600
    SinglePage Allocator                     605944
    
    (5 row(s) affected)
    
    MEMORYCLERK_SQLGENERAL (node 0)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     3128
    MultiPage Allocator                      16344
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLGENERAL (node 1)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     144
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLGENERAL (Total)           KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     3272
    MultiPage Allocator                      16344
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLBUFFERPOOL (node 0)       KB
    ---------------------------------------- -----------
    VM Reserved                              1338232
    VM Committed                             82680
    AWE Allocated                            5414912
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     0
    MultiPage Allocator                      5776
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLQUERYEXEC (node 0)        KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     88
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLOPTIMIZER (node 0)        KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     840
    MultiPage Allocator                      88
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLUTILITIES (node 0)        KB
    ---------------------------------------- -----------
    VM Reserved                              360
    VM Committed                             360
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     320
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLSTORENG (node 0)          KB
    ---------------------------------------- -----------
    VM Reserved                              4992
    VM Committed                             4992
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     14280
    MultiPage Allocator                      200
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLSTORENG (node 1)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     632
    MultiPage Allocator                      2856
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLSTORENG (Total)           KB
    ---------------------------------------- -----------
    VM Reserved                              4992
    VM Committed                             4992
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     14912
    MultiPage Allocator                      3056
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLCONNECTIONPOOL (node 0)   KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     1496
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLCONNECTIONPOOL (node 1)   KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     1224
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLCONNECTIONPOOL (Total)    KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2720
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLCLR (node 0)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     8
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_SQLSERVICEBROKER (node 0)    KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     192
    MultiPage Allocator                      344
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    MEMORYCLERK_SNI (node 0)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     5112
    MultiPage Allocator                      16
    
    (7 row(s) affected)
    
    MEMORYCLERK_SNI (node 1)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     464
    MultiPage Allocator                      16
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    MEMORYCLERK_SNI (Total)                  KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     5576
    MultiPage Allocator                      48
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    MEMORYCLERK_BHF (node 0)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     48
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_BHF (node 1)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     72
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_BHF (Total)                  KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     120
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    MEMORYCLERK_HOST (node 1)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     40
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    MEMORYCLERK_SOSNODE (node 0)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     5776
    MultiPage Allocator                      6000
    
    (7 row(s) affected)
    
    MEMORYCLERK_SOSNODE (node 1)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     3688
    MultiPage Allocator                      2584
    
    (7 row(s) affected)
    
    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                      1520
    
    (7 row(s) affected)
    
    MEMORYCLERK_SOSNODE (Total)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     9480
    MultiPage Allocator                      10104
    
    (7 row(s) affected)
    
    MEMORYCLERK_FULLTEXT_SHMEM (node 0)      KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              192
    SM Committed                             192
    SinglePage Allocator                     0
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    MEMORYCLERK_XE (node 0)                  KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     528
    MultiPage Allocator                      112
    
    (7 row(s) affected)
    
    CACHESTORE_OBJCP (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     137288
    MultiPage Allocator                      3400
    
    (7 row(s) affected)
    
    CACHESTORE_SQLCP (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     335360
    MultiPage Allocator                      8296
    
    (7 row(s) affected)
    
    CACHESTORE_PHDR (node 0)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     14488
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    CACHESTORE_XPROC (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     88
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    CACHESTORE_TEMPTABLES (node 0)           KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     176
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    CACHESTORE_BROKERTBLACS (node 0)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     40
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    CACHESTORE_BROKERTBLACS (node 1)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     88
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    CACHESTORE_BROKERTBLACS (Total)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     128
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    CACHESTORE_SYSTEMROWSET (node 0)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2512
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    CACHESTORE_SYSTEMROWSET (node 1)         KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     368
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    CACHESTORE_SYSTEMROWSET (Total)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2880
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    CACHESTORE_CONVPRI (node 0)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     192
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    CACHESTORE_CONVPRI (Total)               KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     208
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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                      16
    
    (7 row(s) affected)
    
    USERSTORE_SCHEMAMGR (node 0)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     10320
    MultiPage Allocator                      512
    
    (7 row(s) affected)
    
    USERSTORE_DBMETADATA (node 0)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     5632
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_DBMETADATA (node 1)            KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     432
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_DBMETADATA (Total)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     6064
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_TOKENPERM (node 0)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     6024
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_TOKENPERM (node 1)             KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     1512
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_TOKENPERM (Total)              KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     7536
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_OBJPERM (node 0)               KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2440
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_OBJPERM (node 1)               KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     232
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_OBJPERM (Total)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     2672
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_SXC (node 0)                   KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     304
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    USERSTORE_SXC (node 1)                   KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     224
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    USERSTORE_SXC (Total)                    KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     536
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    OBJECTSTORE_LBSS (node 0)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     120
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    OBJECTSTORE_LBSS (node 1)                KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     128
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    OBJECTSTORE_LBSS (Total)                 KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     248
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    OBJECTSTORE_SNI_PACKET (node 0)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     12272
    MultiPage Allocator                      56
    
    (7 row(s) affected)
    
    OBJECTSTORE_SNI_PACKET (node 1)          KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     11912
    MultiPage Allocator                      56
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    OBJECTSTORE_SNI_PACKET (Total)           KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     24184
    MultiPage Allocator                      168
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    OBJECTSTORE_LOCK_MANAGER (node 0)        KB
    ---------------------------------------- -----------
    VM Reserved                              4096
    VM Committed                             4096
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     11768
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    OBJECTSTORE_LOCK_MANAGER (node 1)        KB
    ---------------------------------------- -----------
    VM Reserved                              0
    VM Committed                             0
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     13200
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    OBJECTSTORE_LOCK_MANAGER (Total)         KB
    ---------------------------------------- -----------
    VM Reserved                              4096
    VM Committed                             4096
    AWE Allocated                            0
    SM Reserved                              0
    SM Committed                             0
    SinglePage Allocator                     24992
    MultiPage Allocator                      0
    
    (7 row(s) affected)
    
    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
    
    (7 row(s) affected)
    
    Buffer Pool                              Value
    ---------------------------------------- -----------
    Committed                                676000
    Target                                   2768896
    Database                                 537207
    Dirty                                    7009
    In IO                                    0
    Latched                                  0
    Free                                     63050
    Stolen                                   75743
    Reserved                                 0
    Visible                                  132608
    Stolen Potential                         50234
    Limiting Factor                          10
    Last OOM Factor                          0
    Last OS Error                            0
    Page Life Expectancy                     31849
    
    (15 row(s) affected)
    
    Process/System Counts                    Value
    ---------------------------------------- --------------------
    Available Physical Memory                26520788992
    Available Virtual Memory                 506540032
    Available Paging File                    89230413824
    Working Set                              198598656
    Percent of Committed Memory in WS        100
    Page Faults                              1289177
    System physical memory high              1
    System physical memory low               0
    Process physical memory low              0
    Process virtual memory low               0
    
    (10 row(s) affected)
    
    Procedure Cache                          Value
    ---------------------------------------- -----------
    TotalProcs                               5857
    TotalPages                               62365
    InUsePages                               1005
    
    (3 row(s) affected)
    
    Global Memory Objects                    Pages
    ---------------------------------------- -----------
    Resource                                 351
    Locks                                    3124
    XDES                                     1372
    SETLS                                    8
    SE Dataset Allocators                    16
    SubpDesc Allocators                      8
    SE SchemaManager                         464
    SE Column Metadata Cache                 814
    SQLCache                                 577
    Replication                              2
    ServerGlobal                             27
    XP Global                                2
    SortTables                               2
    
    (13 row(s) affected)
    
    Query Memory Objects (internal)          Value
    ---------------------------------------- -----------
    Grants                                   0
    Waiting                                  0
    Available                                23057
    Current Max                              23057
    Future Max                               23057
    Physical Max                             98432
    Next Request                             0
    Waiting For                              0
    Cost                                     0
    Timeout                                  0
    Wait Time                                0
    
    (11 row(s) affected)
    
    Small Query Memory Objects (internal)    Value
    ---------------------------------------- -----------
    Grants                                   0
    Waiting                                  0
    Available                                1213
    Current Max                              1213
    Future Max                               1213
    
    (5 row(s) affected)
    
    Query Memory Objects (default)           Value
    ---------------------------------------- -----------
    Grants                                   0
    Waiting                                  0
    Available                                44717
    Current Max                              44717
    Future Max                               44717
    Physical Max                             97292
    Next Request                             0
    Waiting For                              0
    Cost                                     0
    Timeout                                  0
    Wait Time                                0
    
    (11 row(s) affected)
    
    Small Query Memory Objects (default)     Value
    ---------------------------------------- -----------
    Grants                                   0
    Waiting                                  0
    Available                                2353
    Current Max                              2353
    Future Max                               2353
    
    (5 row(s) affected)
    
    Optimization Queue (internal)            Value
    ---------------------------------------- -----------
    Overall Memory                           870752256
    Target Memory                            238764032
    Last Notification                        1
    Timeout                                  6
    Early Termination Factor                 5
    
    (5 row(s) affected)
    
    Small Gateway (internal)                 Value
    ---------------------------------------- -----------
    Configured Units                         32
    Available Units                          32
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         250000
    Threshold                                250000
    
    (6 row(s) affected)
    
    Medium Gateway (internal)                Value
    ---------------------------------------- -----------
    Configured Units                         8
    Available Units                          8
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         12
    Threshold                                -1
    
    (6 row(s) affected)
    
    Big Gateway (internal)                   Value
    ---------------------------------------- -----------
    Configured Units                         1
    Available Units                          1
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         8
    Threshold                                -1
    
    (6 row(s) affected)
    
    Optimization Queue (default)             Value
    ---------------------------------------- -----------
    Overall Memory                           870752256
    Target Memory                            224731136
    Last Notification                        1
    Timeout                                  6
    Early Termination Factor                 5
    
    (5 row(s) affected)
    
    Small Gateway (default)                  Value
    ---------------------------------------- -----------
    Configured Units                         32
    Available Units                          32
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         250000
    Threshold                                250000
    
    (6 row(s) affected)
    
    Medium Gateway (default)                 Value
    ---------------------------------------- -----------
    Configured Units                         8
    Available Units                          8
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         12
    Threshold                                -1
    
    (6 row(s) affected)
    
    Big Gateway (default)                    Value
    ---------------------------------------- -----------
    Configured Units                         1
    Available Units                          1
    Acquires                                 0
    Waiters                                  0
    Threshold Factor                         8
    Threshold                                -1
    
    (6 row(s) affected)
    
    Memory Pool Manager                      Pages
    ---------------------------------------- -----------
    Reserved Current                         0
    Reserved Limit                           50234
    
    (2 row(s) affected)
    
    Memory Pool (internal)                   Pages
    ---------------------------------------- -----------
    Allocations                              7746
    Predicted                                7749
    Private Target                           0
    Private Limit                            0
    Total Target                             125977
    Total Limit                              125977
    OOM Count                                0
    
    (7 row(s) affected)
    
    MEMORYBROKER_FOR_CACHE (internal)        Pages
    ---------------------------------------- -----------
    Allocations                              4503
    Rate                                     0
    Target Allocations                       30403
    Future Allocations                       0
    Overall                                  106293
    Last Notification                        1
    
    (6 row(s) affected)
    
    MEMORYBROKER_FOR_STEAL (internal)        Pages
    ---------------------------------------- -----------
    Allocations                              3243
    Rate                                     3
    Target Allocations                       29146
    Future Allocations                       0
    Overall                                  106293
    Last Notification                        1
    
    (6 row(s) affected)
    
    MEMORYBROKER_FOR_RESERVE (internal)      Pages
    ---------------------------------------- -----------
    Allocations                              0
    Rate                                     0
    Target Allocations                       25900
    Future Allocations                       0
    Overall                                  106293
    Last Notification                        1
    
    (6 row(s) affected)
    
    Memory Pool (default)                    Pages
    ---------------------------------------- -----------
    Allocations                              67997
    Predicted                                92328
    Private Target                           0
    Private Limit                            0
    Total Target                             125977
    Total Limit                              125977
    OOM Count                                0
    
    (7 row(s) affected)
    
    MEMORYBROKER_FOR_CACHE (default)         Pages
    ---------------------------------------- -----------
    Allocations                              66466
    Rate                                     7
    Target Allocations                       92373
    Future Allocations                       0
    Overall                                  106293
    Last Notification                        1
    
    (6 row(s) affected)
    
    MEMORYBROKER_FOR_STEAL (default)         Pages
    ---------------------------------------- -----------
    Allocations                              1531
    Rate                                     2
    Target Allocations                       27433
    Future Allocations                       0
    Overall                                  106293
    Last Notification                        1
    
    (6 row(s) affected)
    
    MEMORYBROKER_FOR_RESERVE (default)       Pages
    ---------------------------------------- -----------
    Allocations                              0
    Rate                                     0
    Target Allocations                       50222
    Future Allocations                       24323
    Overall                                  106293
    Last Notification                        1
    
    (6 row(s) affected)
    
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.
    


    Wednesday, December 16, 2015 2:52 PM