Memory issue after running a large query

  • I have recently experienced some memory related errors after running a very large query which does a lot of DML operations.

    Data was mainly being updated/inserted. Details of the error can be found below.

    Output of DBCC MEMORYSTATUS

    Memory Manager|KB

    VM Reserved|1041192

    VM Committed|92008

    AWE Allocated|5242880

    Reserved Memory|1024

    Reserved Memory In Use|0

    Memory node Id = 0|KB

    VM Reserved|1038376

    VM Committed|89304

    AWE Allocated|5242880

    MultiPage Allocator|19416

    SinglePage Allocator|99192

    Memory node Id = 32|KB

    VM Reserved|1728

    VM Committed|1672

    AWE Allocated|0

    MultiPage Allocator|1600

    SinglePage Allocator|99192

    MEMORYCLERK_SQLGENERAL (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|3216

    MultiPage Allocator|2792

    MEMORYCLERK_SQLBUFFERPOOL (node 0)|KB

    VM Reserved|1002168

    VM Committed|54352

    AWE Allocated|5242880

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|0

    MultiPage Allocator|2128

    MEMORYCLERK_SQLQUERYEXEC (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_SQLOPTIMIZER (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|328

    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|288

    MultiPage Allocator|0

    MEMORYCLERK_SQLSTORENG (node 0)|KB

    VM Reserved|6400

    VM Committed|6400

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|6640

    MultiPage Allocator|3064

    MEMORYCLERK_SQLCONNECTIONPOOL (node 0)|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|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|8

    MultiPage Allocator|0

    MEMORYCLERK_SQLSERVICEBROKER (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|200

    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|104

    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|104

    MultiPage Allocator|32

    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_BHF (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|72

    MultiPage Allocator|0

    MEMORYCLERK_XE_BUFFER (node 0)|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 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|24

    MultiPage Allocator|0

    MEMORYCLERK_SOSNODE (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|4280

    MultiPage Allocator|6072

    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

    MEMORYCLERK_SOSNODE (Total)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|4296

    MultiPage Allocator|7592

    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

    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|232

    MultiPage Allocator|3232

    CACHESTORE_OBJCP (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|3056

    MultiPage Allocator|48

    CACHESTORE_SQLCP (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|21232

    MultiPage Allocator|400

    CACHESTORE_PHDR (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|12208

    MultiPage Allocator|0

    CACHESTORE_XPROC (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|48

    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 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|16

    CACHESTORE_BROKERTBLACS (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|168

    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_SYSTEMROWSET (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|888

    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|288

    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|7640

    MultiPage Allocator|400

    USERSTORE_DBMETADATA (node 0)|KB

    VM Reserved|0

    VM Committed|0

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|3776

    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|1384

    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|2856

    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|88

    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|96

    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|176

    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|8792

    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|8792

    MultiPage Allocator|112

    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|4096

    VM Committed|4096

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|20008

    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|4096

    VM Committed|4096

    AWE Allocated|0

    SM Reserved|0

    SM Committed|0

    SinglePage Allocator|20032

    MultiPage Allocator|0

    Buffer Pool|Value

    Committed|655360

    Target|655360

    Database|341093

    Dirty|18707

    In IO|0

    Latched|0

    Free|301868

    Stolen|12399

    Reserved|0

    Visible|116224

    Stolen Potential|98013

    Limiting Factor|10

    Last OOM Factor|0

    Page Life Expectancy|181269

    Process/System Counts|Value

    Available Physical Memory|1965166592

    Available Virtual Memory|825503744

    Available Paging File|3830452224

    Working Set|144482304

    Percent of Committed Memory in WS|100

    Page Faults|7979734

    System physical memory high|1

    System physical memory low|0

    Process physical memory low|0

    Process virtual memory low|0

    Procedure Cache|Value

    TotalProcs|374

    TotalPages|4624

    InUsePages|11

    Global Memory Objects|Pages

    Resource|361

    Locks|2504

    XDES|212

    SETLS|8

    SE Dataset Allocators|16

    SubpDesc Allocators|8

    SE SchemaManager|446

    SE Column Metadata Cache|558

    SQLCache|62

    Replication|2

    ServerGlobal|28

    XP Global|2

    SortTables|2

    Query Memory Objects (internal)|Value

    Grants|0

    Waiting|0

    Available|82964

    Current Max|82964

    Future Max|82964

    Physical Max|82964

    Next Request|0

    Waiting For|0

    Cost|0

    Timeout|0

    Wait Time|0

    Small Query Memory Objects (internal)|Value

    Grants|0

    Waiting|0

    Available|4366

    Current Max|4366

    Future Max|4366

    Optimization Queue (internal)|Value

    Overall Memory|763166720

    Target Memory|649379840

    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

    Memory Pool Manager|Pages

    Reserved Current|0

    Reserved Limit|98017

    Memory Pool (internal)|Pages

    Allocations|12395

    Predicted|33136

    Private Target|0

    Private Limit|0

    Total Target|110412

    Total Limit|110412

    OOM Count|11

    MEMORYBROKER_FOR_CACHE (internal)|Pages

    Allocations|10401

    Rate|0

    Target Allocations|87677

    Future Allocations|0

    Overall|93160

    Last Notification|1

    MEMORYBROKER_FOR_STEAL (internal)|Pages

    Allocations|1994

    Rate|0

    Target Allocations|79270

    Future Allocations|0

    Overall|93160

    Last Notification|1

    MEMORYBROKER_FOR_RESERVE (internal)|Pages

    Allocations|0

    Rate|0

    Target Allocations|93160

    Future Allocations|20741

    Overall|93160

    Last Notification|1

    Also queried memory related DMVs

    type VM Reserved VM Committed AWE Allocated SM Reserved SM Committed MultiPage Allocator SinlgePage Allocator

    CACHESTORE_SQLCP 0 0 0 0 0 368 21032

    OBJECTSTORE_LOCK_MANAGER 4096 4096 0 0 0 0 20032

    CACHESTORE_PHDR 0 0 0 0 0 0 12200

    OBJECTSTORE_SNI_PACKET 0 0 0 0 0 112 8792

    USERSTORE_SCHEMAMGR 0 0 0 0 0 400 7640

    MEMORYCLERK_SQLSTORENG 6400 6400 0 0 0 3064 6640

    MEMORYCLERK_SOSNODE 0 0 0 0 0 7592 4288

    USERSTORE_DBMETADATA 0 0 0 0 0 0 3776

    MEMORYCLERK_SQLGENERAL 0 0 0 0 0 2792 3216

    CACHESTORE_OBJCP 0 0 0 0 0 48 3056

    USERSTORE_OBJPERM 0 0 0 0 0 0 2856

    USERSTORE_TOKENPERM 0 0 0 0 0 0 1384

    CACHESTORE_SYSTEMROWSET 0 0 0 0 0 0 888

    MEMORYCLERK_SQLCONNECTIONPOOL 0 0 0 0 0 0 440

    OBJECTSTORE_SERVICE_BROKER 0 0 0 0 0 0 400

    MEMORYCLERK_SQLOPTIMIZER 0 0 0 0 0 88 328

    CACHESTORE_CONVPRI 0 0 0 0 0 0 288

    MEMORYCLERK_SQLUTILITIES 240 240 0 0 0 0 272

    MEMORYCLERK_XE 0 0 0 0 0 3232 232

    MEMORYCLERK_SQLSERVICEBROKER 0 0 0 0 0 344 200

    OBJECTSTORE_LBSS 0 0 0 0 0 0 176

    CACHESTORE_BROKERTBLACS 0 0 0 0 0 0 168

    MEMORYCLERK_SNI 0 0 0 0 0 32 104

    USERSTORE_SXC 0 0 0 0 0 0 96

    MEMORYCLERK_BHF 0 0 0 0 0 0 72

    CACHESTORE_XPROC 0 0 0 0 0 0 48

    MEMORYCLERK_SQLQUERYEXEC 0 0 0 0 0 0 40

    MEMORYCLERK_SQLSERVICEBROKERTRANSPORT 0 0 0 0 0 0 32

    CACHESTORE_FULLTEXTSTOPLIST 0 0 0 0 0 0 32

    CACHESTORE_BROKERREADONLY 0 0 0 0 0 0 32

    MEMORYCLERK_FULLTEXT 0 0 0 0 0 0 24

    MEMORYCLERK_HOST 0 0 0 0 0 0 24

    MEMORYCLERK_SQLXP 0 0 0 0 0 0 16

    CACHESTORE_VIEWDEFINITIONS 0 0 0 0 0 0 16

    CACHESTORE_TEMPTABLES 0 0 0 0 0 0 16

    CACHESTORE_EVENTS 0 0 0 0 0 0 16

    CACHESTORE_NOTIF 0 0 0 0 0 0 16

    CACHESTORE_XMLDBELEMENT 0 0 0 0 0 0 8

    MEMORYCLERK_SQLHTTP 0 0 0 0 0 0 8

    CACHESTORE_XMLDBATTRIBUTE 0 0 0 0 0 0 8

    CACHESTORE_BROKERRSB 0 0 0 0 0 0 8

    CACHESTORE_XMLDBTYPE 0 0 0 0 0 0 8

    CACHESTORE_BROKERUSERCERTLOOKUP 0 0 0 0 0 0 8

    CACHESTORE_BROKERTO 0 0 0 0 0 0 8

    CACHESTORE_BROKERKEK 0 0 0 0 0 0 8

    MEMORYCLERK_SQLCLR 0 0 0 0 0 0 8

    CACHESTORE_BROKERDSH 0 0 0 0 0 0 8

    MEMORYCLERK_SQLSOAPSESSIONSTORE 0 0 0 0 0 0 0

    MEMORYCLERK_SQLQERESERVATIONS 0 0 0 0 0 0 0

    MEMORYCLERK_FULLTEXT_SHMEM 0 0 0 192 192 0 0

    MEMORYCLERK_SQLXML 0 0 0 0 0 0 0

    MEMORYCLERK_SQLQUERYCOMPILE 0 0 0 0 0 0 0

    MEMORYCLERK_XE_BUFFER 4224 4224 0 0 0 0 0

    MEMORYCLERK_SQLQUERYPLAN 0 0 0 0 0 0 0

    CACHESTORE_STACKFRAMES 0 0 0 0 0 16 0

    MEMORYCLERK_SQLCLRASSEMBLY 0 0 0 0 0 0 0

    MEMORYCLERK_QSRANGEPREFETCH 0 0 0 0 0 0 0

    MEMORYCLERK_SQLBUFFERPOOL 1002168 54352 5242880 0 0 2128 0

    MEMORYCLERK_SQLSOAP 0 0 0 0 0 0 0

    MEMORYCLERK_TRACE_EVTNOTIF 0 0 0 0 0 0 0

  • Adding a bit of more information.

    Source,Severity,Message

    spid74,Unknown,There is insufficient system memory in resource pool 'internal' to run this query.

    spid74,Unknown,MEMORYBROKER_FOR_RESERVE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 0<nl/>Rate 0<nl/>Target Allocations 2911<nl/>Future Allocations 21672<nl/>Overall 93160<nl/>Last Notification 0

    spid74,Unknown,MEMORYBROKER_FOR_STEAL (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 1999<nl/>Rate -291<nl/>Target Allocations 2911<nl/>Future Allocations 0<nl/>Overall 93160<nl/>Last Notification 0

    spid74,Unknown,MEMORYBROKER_FOR_CACHE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 106862<nl/>Rate 23948<nl/>Target Allocations 78876<nl/>Future Allocations 0<nl/>Overall 93160<nl/>Last Notification 2

    spid74,Unknown,Memory Pool (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 108861<nl/>Predicted 154481<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 110412<nl/>Total Limit 110412<nl/>OOM Count 1

    spid74,Unknown,Memory Pool Manager Pages<nl/>---------------------------------------- ----------<nl/>Reserved Current 0<nl/>Reserved Limit 1551

    spid74,Unknown,Big Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1<nl/>Available Units 1<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 8<nl/>Threshold -1

    spid74,Unknown,Medium Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 8<nl/>Available Units 8<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold -1

    spid74,Unknown,Small Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 32<nl/>Available Units 32<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 250000<nl/>Threshold 250000

    spid74,Unknown,Optimization Queue (internal) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 763166720<nl/>Target Memory 23846912<nl/>Last Notification 0<nl/>Timeout 6<nl/>Early Termination Factor 5

    spid74,Unknown,Small Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 640<nl/>Current Max 640<nl/>Future Max 640

    spid74,Unknown,Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 2075<nl/>Current Max 2075<nl/>Future Max 2075<nl/>Physical Max 86690<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 0

    spid74,Unknown,Global Memory Objects Pages<nl/>---------------------------------------- ----------<nl/>Resource 361<nl/>Locks 645<nl/>XDES 213<nl/>SETLS 8<nl/>SE Dataset Allocators 16<nl/>SubpDesc Allocators 8<nl/>SE SchemaManager 450<nl/>SE Column Metadata Cache 564<nl/>SQLCache 1385<nl/>Replication 2<nl/>ServerGlobal 28<nl/>XP Global 2<nl/>SortTables 2

    spid74,Unknown,Procedure Cache Value<nl/>---------------------------------------- ----------<nl/>TotalProcs 0<nl/>TotalPages 113755<nl/>InUsePages 0

    spid74,Unknown,Process/System Counts Value<nl/>---------------------------------------- ----------<nl/>Available Physical Memory 1773412352<nl/>Available Virtual Memory 729296896<nl/>Available Paging File 3746148352<nl/>Working Set 215150592<nl/>Percent of Committed Memory in WS 100<nl/>Page Faults 7977676<nl/>System physical memory high 1<nl/>System physical memory low 0<nl/>Process physical memory low 1<nl/>Process virtual memory low 0

    spid74,Unknown,Buffer Pool Value<nl/>---------------------------------------- ----------<nl/>Committed 655360<nl/>Target 655360<nl/>Database 340345<nl/>Dirty 42396<nl/>In IO 0<nl/>Latched 0<nl/>Free 204603<nl/>Stolen 110412<nl/>Reserved 0<nl/>Visible 116224<nl/>Stolen Potential 0<nl/>Limiting Factor 10<nl/>Last OOM Factor 0<nl/>Page Life Expectancy 178191

    spid74,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 4096<nl/>VM Committed 4096<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 5160<nl/>MultiPage Allocator 0

    spid74,Unknown,OBJECTSTORE_LOCK_MANAGER (node 32) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0

    spid74,Unknown,OBJECTSTORE_LOCK_MANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 4096<nl/>VM Committed 4096<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 5136<nl/>MultiPage Allocator 0

    spid74,Unknown,OBJECTSTORE_SERVICE_BROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 400<nl/>MultiPage Allocator 0

    spid74,Unknown,OBJECTSTORE_SNI_PACKET (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 11264<nl/>MultiPage Allocator 112

    spid74,Unknown,OBJECTSTORE_SNI_PACKET (node 32) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 56

    spid74,Unknown,OBJECTSTORE_SNI_PACKET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 11264<nl/>MultiPage Allocator 56

    spid74,Unknown,OBJECTSTORE_LBSS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 128<nl/>MultiPage Allocator 0

    spid74,Unknown,USERSTORE_SXC (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 104<nl/>MultiPage Allocator 0

    spid74,Unknown,USERSTORE_SXC (node 32) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,USERSTORE_SXC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 96<nl/>MultiPage Allocator 0

    spid74,Unknown,USERSTORE_OBJPERM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 2856<nl/>MultiPage Allocator 0

    spid74,Unknown,USERSTORE_TOKENPERM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1120<nl/>MultiPage Allocator 0

    spid74,Unknown,USERSTORE_DBMETADATA (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 640<nl/>MultiPage Allocator 0

    spid74,Unknown,USERSTORE_SCHEMAMGR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 7720<nl/>MultiPage Allocator 400

    spid74,Unknown,CACHESTORE_FULLTEXTSTOPLIST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_CONVPRI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 288<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_SYSTEMROWSET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 248<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_EVENTS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_BROKERTO (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_BROKERREADONLY (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_BROKERRSB (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_BROKERDSH (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_BROKERKEK (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_BROKERTBLACS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 168<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_STACKFRAMES (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 16

    spid74,Unknown,CACHESTORE_STACKFRAMES (node 32) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 8

    spid74,Unknown,CACHESTORE_STACKFRAMES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 8

    spid74,Unknown,CACHESTORE_XMLDBATTRIBUTE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_XMLDBELEMENT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_XMLDBTYPE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_VIEWDEFINITIONS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_NOTIF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_TEMPTABLES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_XPROC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_PHDR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,CACHESTORE_SQLCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 836992<nl/>MultiPage Allocator 73016

    spid74,Unknown,CACHESTORE_OBJCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_XE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 232<nl/>MultiPage Allocator 3160

    spid74,Unknown,MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 192<nl/>SM Committed 192<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_SOSNODE (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4296<nl/>MultiPage Allocator 7592

    spid74,Unknown,MEMORYCLERK_SOSNODE (node 32) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 1520

    spid74,Unknown,MEMORYCLERK_SOSNODE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4280<nl/>MultiPage Allocator 6072

    spid74,Unknown,MEMORYCLERK_HOST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_XE_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 4224<nl/>VM Committed 4224<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_BHF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 96<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_SQLXP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_FULLTEXT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_SNI (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 112<nl/>MultiPage Allocator 32

    spid74,Unknown,MEMORYCLERK_SNI (node 32) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 16

    spid74,Unknown,MEMORYCLERK_SNI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 112<nl/>MultiPage Allocator 16

    spid74,Unknown,MEMORYCLERK_SQLHTTP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_SQLSERVICEBROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 200<nl/>MultiPage Allocator 344

    spid74,Unknown,MEMORYCLERK_SQLCLR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 456<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_SQLSTORENG (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 6400<nl/>VM Committed 6400<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 6648<nl/>MultiPage Allocator 3064

    spid74,Unknown,MEMORYCLERK_SQLUTILITIES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 240<nl/>VM Committed 240<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 272<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_SQLOPTIMIZER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 328<nl/>MultiPage Allocator 88

    spid74,Unknown,MEMORYCLERK_SQLQUERYEXEC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0

    spid74,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 1002168<nl/>VM Committed 54352<nl/>AWE Allocated 5242880<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 2128

    spid74,Unknown,MEMORYCLERK_SQLGENERAL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>AWE Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3216<nl/>MultiPage Allocator 2792

    spid74,Unknown,Memory node Id = 32 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 1728<nl/>VM Committed 1672<nl/>AWE Allocated 0<nl/>MultiPage Allocator 1600<nl/>SinglePage Allocator 883296

    spid74,Unknown,Memory node Id = 0 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 1132328<nl/>VM Committed 182952<nl/>AWE Allocated 5242880<nl/>MultiPage Allocator 91912<nl/>SinglePage Allocator 883296

    spid74,Unknown,Memory Manager KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 1135144<nl/>VM Committed 185656<nl/>AWE Allocated 5242880<nl/>Reserved Memory 1024<nl/>Reserved Memory In Use 0

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

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