January 18, 2010 at 4:52 am
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
typeVM ReservedVM CommittedAWE AllocatedSM ReservedSM CommittedMultiPage AllocatorSinlgePage Allocator
CACHESTORE_SQLCP0000036821032
OBJECTSTORE_LOCK_MANAGER40964096000020032
CACHESTORE_PHDR00000012200
OBJECTSTORE_SNI_PACKET000001128792
USERSTORE_SCHEMAMGR000004007640
MEMORYCLERK_SQLSTORENG6400640000030646640
MEMORYCLERK_SOSNODE0000075924288
USERSTORE_DBMETADATA0000003776
MEMORYCLERK_SQLGENERAL0000027923216
CACHESTORE_OBJCP00000483056
USERSTORE_OBJPERM0000002856
USERSTORE_TOKENPERM0000001384
CACHESTORE_SYSTEMROWSET000000888
MEMORYCLERK_SQLCONNECTIONPOOL000000440
OBJECTSTORE_SERVICE_BROKER000000400
MEMORYCLERK_SQLOPTIMIZER0000088328
CACHESTORE_CONVPRI000000288
MEMORYCLERK_SQLUTILITIES2402400000272
MEMORYCLERK_XE000003232232
MEMORYCLERK_SQLSERVICEBROKER00000344200
OBJECTSTORE_LBSS000000176
CACHESTORE_BROKERTBLACS000000168
MEMORYCLERK_SNI0000032104
USERSTORE_SXC00000096
MEMORYCLERK_BHF00000072
CACHESTORE_XPROC00000048
MEMORYCLERK_SQLQUERYEXEC00000040
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT00000032
CACHESTORE_FULLTEXTSTOPLIST00000032
CACHESTORE_BROKERREADONLY00000032
MEMORYCLERK_FULLTEXT00000024
MEMORYCLERK_HOST00000024
MEMORYCLERK_SQLXP00000016
CACHESTORE_VIEWDEFINITIONS00000016
CACHESTORE_TEMPTABLES00000016
CACHESTORE_EVENTS00000016
CACHESTORE_NOTIF00000016
CACHESTORE_XMLDBELEMENT0000008
MEMORYCLERK_SQLHTTP0000008
CACHESTORE_XMLDBATTRIBUTE0000008
CACHESTORE_BROKERRSB0000008
CACHESTORE_XMLDBTYPE0000008
CACHESTORE_BROKERUSERCERTLOOKUP0000008
CACHESTORE_BROKERTO0000008
CACHESTORE_BROKERKEK0000008
MEMORYCLERK_SQLCLR0000008
CACHESTORE_BROKERDSH0000008
MEMORYCLERK_SQLSOAPSESSIONSTORE0000000
MEMORYCLERK_SQLQERESERVATIONS0000000
MEMORYCLERK_FULLTEXT_SHMEM00019219200
MEMORYCLERK_SQLXML0000000
MEMORYCLERK_SQLQUERYCOMPILE0000000
MEMORYCLERK_XE_BUFFER4224422400000
MEMORYCLERK_SQLQUERYPLAN0000000
CACHESTORE_STACKFRAMES00000160
MEMORYCLERK_SQLCLRASSEMBLY0000000
MEMORYCLERK_QSRANGEPREFETCH0000000
MEMORYCLERK_SQLBUFFERPOOL10021685435252428800021280
MEMORYCLERK_SQLSOAP0000000
MEMORYCLERK_TRACE_EVTNOTIF0000000
January 18, 2010 at 5:03 am
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