Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Process/System Counts Value
------------------------------------------------------------------------ --------------------
Available Physical Memory 26190585856
Available Virtual Memory 140668500267008
Available Paging File 31710347264
Working Set 170340352
Percent of Committed Memory in WS 100
Page Faults 139155
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 0
(10 rows affected)
Memory Manager KB
------------------------------------------------------------------------ -----------
VM Reserved 66773016
VM Committed 387272
Locked Pages Allocated 7099344
Large Pages Allocated 264192
Emergency Memory 1024
Emergency Memory In Use 16
Target Committed 31104568
Current Committed 7486616
Pages Allocated 6657384
Pages Reserved 691160
Pages Free 262872
Pages In Use 3198488
Page Alloc Potential 26685928
NUMA Growth Phase 0
Last OOM Factor 0
Last OS Error 0
(16 rows affected)
Memory node Id = 0 KB
------------------------------------------------------------------------ -----------
VM Reserved 66740056
VM Committed 354432
Locked Pages Allocated 7099344
Pages Allocated 6657384
Pages Free 262872
Target Committed 31071720
Current Committed 7453776
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
(10 rows affected)
Memory node Id = 1 KB
------------------------------------------------------------------------ -----------
VM Reserved 32768
VM Committed 32804
Locked Pages Allocated 0
Pages Allocated 0
Pages Free 0
Target Committed 32808
Current Committed 32808
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
(10 rows affected)
Memory node Id = 64 KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 36
Locked Pages Allocated 0
(3 rows affected)
MEMORYCLERK_XE_BUFFER (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 8448
VM Committed 8448
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_XE_BUFFER (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 4224
VM Committed 4224
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_XE_BUFFER (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 12672
VM Committed 12672
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_HOST (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 248
(6 rows affected)
MEMORYCLERK_SOSNODE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 47360
(6 rows affected)
MEMORYCLERK_SOSNODE (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 11568
(6 rows affected)
MEMORYCLERK_SOSNODE (node 64) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3024
(6 rows affected)
MEMORYCLERK_SOSNODE (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 61952
(6 rows affected)
MEMORYCLERK_SOSOS (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 36
VM Committed 36
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1440
(6 rows affected)
MEMORYCLERK_SOSMEMMANAGER (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 98752
VM Committed 96192
Locked Pages Allocated 2472
SM Reserved 0
SM Committed 0
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_BITMAP (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 2097152
VM Committed 484
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_SQLGENERAL (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 23056
(6 rows affected)
MEMORYCLERK_SQLGENERAL (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192
(6 rows affected)
MEMORYCLERK_SQLGENERAL (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 23248
(6 rows affected)
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 29286108
VM Committed 75776
Locked Pages Allocated 115752
SM Reserved 0
SM Committed 0
Pages Allocated 4716352
(6 rows affected)
MEMORYCLERK_SQLQUERYPLAN (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1816
(6 rows affected)
MEMORYCLERK_SQLQUERYEXEC (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 18968
(6 rows affected)
MEMORYCLERK_SQLQUERYEXEC (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 31752
(6 rows affected)
MEMORYCLERK_SQLQUERYEXEC (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 50720
(6 rows affected)
MEMORYCLERK_SQLOPTIMIZER (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1296
(6 rows affected)
MEMORYCLERK_QUERYDISKSTORE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 240
(6 rows affected)
MEMORYCLERK_QUERYDISKSTORE_STATS (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48
(6 rows affected)
MEMORYCLERK_SQLUTILITIES (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 520
(6 rows affected)
MEMORYCLERK_SQLSTORENG (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 60864
VM Committed 0
Locked Pages Allocated 60864
SM Reserved 0
SM Committed 0
Pages Allocated 108744
(6 rows affected)
MEMORYCLERK_SQLSTORENG (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 10088
(6 rows affected)
MEMORYCLERK_SQLSTORENG (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 60864
VM Committed 0
Locked Pages Allocated 60864
SM Reserved 0
SM Committed 0
Pages Allocated 118832
(6 rows affected)
MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3008
(6 rows affected)
MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2696
(6 rows affected)
MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5704
(6 rows affected)
MEMORYCLERK_SQLCLR (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 3545728
VM Committed 4156
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24928
(6 rows affected)
MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2112
(6 rows affected)
MEMORYCLERK_SQLSERVICEBROKER (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_SQLSERVICEBROKER (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2128
(6 rows affected)
MEMORYCLERK_SQLHTTP (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
MEMORYCLERK_SNI (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 88
(6 rows affected)
MEMORYCLERK_SNI (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 128
(6 rows affected)
MEMORYCLERK_SNI (node 64) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_SNI (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 232
(6 rows affected)
MEMORYCLERK_FULLTEXT (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 296
(6 rows affected)
MEMORYCLERK_SQLXP (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_BHF (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_BHF (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
MEMORYCLERK_BHF (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
(6 rows affected)
MEMORYCLERK_SQLQERESERVATIONS (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 275032
(6 rows affected)
MEMORYCLERK_SQLQERESERVATIONS (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 547448
(6 rows affected)
MEMORYCLERK_SQLQERESERVATIONS (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 822480
(6 rows affected)
MEMORYCLERK_SQLTRACE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2232
(6 rows affected)
MEMORYCLERK_XTP (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2720
(6 rows affected)
MEMORYCLERK_CSILOBCOMPRESSION (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 72
(6 rows affected)
MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 216
SM Committed 216
Pages Allocated 0
(6 rows affected)
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 328
(6 rows affected)
MEMORYCLERK_FSAGENT (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
(6 rows affected)
MEMORYCLERK_FILETABLE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 72
(6 rows affected)
MEMORYCLERK_SPATIAL (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 144
(6 rows affected)
MEMORYCLERK_HADR (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40
(6 rows affected)
MEMORYCLERK_SQLLOGPOOL (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12000
(6 rows affected)
MEMORYCLERK_LWC (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 72
(6 rows affected)
MEMORYCLERK_FSCHUNKER (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
(6 rows affected)
MEMORYCLERK_SVL (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
MEMORYCLERK_SLOG (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 448
(6 rows affected)
MEMORYCLERK_SLOG (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
(6 rows affected)
MEMORYCLERK_SLOG (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 480
(6 rows affected)
MEMORYCLERK_QUERYPROFILE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 11448
(6 rows affected)
MEMORYCLERK_POLYBASE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_STACKFRAMES (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_STACKFRAMES (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_STACKFRAMES (node 64) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_STACKFRAMES (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
(6 rows affected)
CACHESTORE_OBJCP (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 94872
(6 rows affected)
CACHESTORE_SQLCP (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 524312
(6 rows affected)
CACHESTORE_PHDR (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 532968
(6 rows affected)
CACHESTORE_XPROC (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 112
(6 rows affected)
CACHESTORE_TEMPTABLES (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 112
(6 rows affected)
CACHESTORE_NOTIF (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_VIEWDEFINITIONS (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_XMLDBTYPE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_XMLDBELEMENT (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERTBLACS (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 176
(6 rows affected)
CACHESTORE_BROKERTBLACS (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 120
(6 rows affected)
CACHESTORE_BROKERTBLACS (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 296
(6 rows affected)
CACHESTORE_BROKERKEK (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERDSH (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERRSB (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_BROKERREADONLY (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
(6 rows affected)
CACHESTORE_BROKERTO (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
CACHESTORE_EVENTS (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 968
(6 rows affected)
CACHESTORE_SYSTEMROWSET (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 41016
(6 rows affected)
CACHESTORE_SYSTEMROWSET (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4136
(6 rows affected)
CACHESTORE_SYSTEMROWSET (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 45152
(6 rows affected)
CACHESTORE_CONVPRI (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64
(6 rows affected)
CACHESTORE_CONVPRI (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_CONVPRI (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
(6 rows affected)
CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
(6 rows affected)
CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 72
(6 rows affected)
CACHESTORE_QDSRUNTIMESTATS (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
CACHESTORE_XML_SELECTIVE_DG (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
USERSTORE_SCHEMAMGR (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 35912
(6 rows affected)
USERSTORE_DBMETADATA (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 159600
(6 rows affected)
USERSTORE_DBMETADATA (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 11104
(6 rows affected)
USERSTORE_DBMETADATA (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 170704
(6 rows affected)
USERSTORE_TOKENPERM (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 21968
(6 rows affected)
USERSTORE_TOKENPERM (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4112
(6 rows affected)
USERSTORE_TOKENPERM (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 26080
(6 rows affected)
USERSTORE_OBJPERM (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 15912
(6 rows affected)
USERSTORE_OBJPERM (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 360
(6 rows affected)
USERSTORE_OBJPERM (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16272
(6 rows affected)
USERSTORE_SXC (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 104
(6 rows affected)
USERSTORE_SXC (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 168
(6 rows affected)
USERSTORE_SXC (node 64) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
(6 rows affected)
USERSTORE_SXC (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 280
(6 rows affected)
USERSTORE_QDSSTMT (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 880
(6 rows affected)
USERSTORE_QDSSTMT (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
(6 rows affected)
USERSTORE_QDSSTMT (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 912
(6 rows affected)
OBJECTSTORE_LBSS (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 224
(6 rows affected)
OBJECTSTORE_LBSS (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 176
(6 rows affected)
OBJECTSTORE_LBSS (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 400
(6 rows affected)
OBJECTSTORE_SNI_PACKET (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1440
(6 rows affected)
OBJECTSTORE_SNI_PACKET (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1704
(6 rows affected)
OBJECTSTORE_SNI_PACKET (node 64) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64
(6 rows affected)
OBJECTSTORE_SNI_PACKET (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3208
(6 rows affected)
OBJECTSTORE_SERVICE_BROKER (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 432
(6 rows affected)
OBJECTSTORE_SERVICE_BROKER (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 128
(6 rows affected)
OBJECTSTORE_SERVICE_BROKER (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 560
(6 rows affected)
OBJECTSTORE_LOCK_MANAGER (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 131072
VM Committed 131072
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 14448
(6 rows affected)
OBJECTSTORE_LOCK_MANAGER (node 1) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12272
(6 rows affected)
OBJECTSTORE_LOCK_MANAGER (node 64) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
(6 rows affected)
OBJECTSTORE_LOCK_MANAGER (Total) KB
------------------------------------------------------------------------ -----------
VM Reserved 131072
VM Committed 131072
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 26744
(6 rows affected)
OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
(6 rows affected)
OBJECTSTORE_XACT_CACHE (node 0) KB
------------------------------------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2992
(6 rows affected)
Buffer Pool Pages
------------------------------------------------------------------------ -----------
Database 589543
Simulated 0
Target 73695232
Dirty 103505
In IO 0
Latched 7
IO error 12590
Page Life Expectancy 5936
(8 rows affected)
Buffer Pool Current Clock Stats Count
------------------------------------------------------------------------ -----------
Never Used 0
Stolen or Free 0
Above Cutoff 0
Not on LRU 0
Single Use 0
Long IO Queue 0
In IO 0
In Allocation 0
Preemptive 0
Skip Pool 0
Moved to L2 0
Evicted 0
Evicted Mapped 0
(13 rows affected)
Buffer Pool Previous Clock Stats Count
------------------------------------------------------------------------ -----------
Never Used 0
Stolen or Free 0
Above Cutoff 0
Not on LRU 0
Single Use 0
Long IO Queue 0
In IO 0
In Allocation 0
Preemptive 0
Skip Pool 0
Moved to L2 0
Evicted 0
Evicted Mapped 0
(13 rows affected)
Procedure Cache Value
------------------------------------------------------------------------ -----------
TotalProcs 7028
TotalPages 144033
InUsePages 1074
(3 rows affected)
Global Memory Objects Pages
------------------------------------------------------------------------ -----------
Resource 1048
Locks 3343
XDES 221
DirtyPageTracking 339
SETLS 9
SubpDesc Allocators 9
SE SchemaManager 2690
SE Column Metadata Cache 1798
SE Column Metadata Cache Store 14
SQLCache 356
Replication 2
ServerGlobal 1278
XP Global 2
SortTables 3
(14 rows affected)
Query Memory Objects (internal) Value
------------------------------------------------------------------------ -----------
Grants 0
Waiting 0
Available 2439574
Current Max 2439574
Future Max 2439574
Physical Max 2845969
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
(11 rows affected)
Small Query Memory Objects (internal) Value
------------------------------------------------------------------------ -----------
Grants 0
Waiting 0
Available 75776
Current Max 75776
Future Max 75776
(5 rows affected)
Query Memory Objects (default) Value
------------------------------------------------------------------------ -----------
Grants 6
Waiting 0
Available 2743159
Current Max 2845969
Future Max 2845969
Physical Max 2845969
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
(11 rows affected)
Small Query Memory Objects (default) Value
------------------------------------------------------------------------ -----------
Grants 0
Waiting 0
Available 75776
Current Max 75776
Future Max 75776
(5 rows affected)
Optimization Queue (internal) Value
------------------------------------------------------------------------ --------------------
Overall Memory 25530621952
Target Memory 22223994880
Last Notification 1
Timeout 6
Early Termination Factor 5
(5 rows affected)
Small Gateway (internal) Value
------------------------------------------------------------------------ -----------
Configured Units 36
Available Units 36
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
(6 rows affected)
Medium Gateway (internal) Value
------------------------------------------------------------------------ -----------
Configured Units 9
Available Units 9
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
(6 rows affected)
Big Gateway (internal) Value
------------------------------------------------------------------------ -----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
(6 rows affected)
Optimization Queue (default) Value
------------------------------------------------------------------------ --------------------
Overall Memory 25530621952
Target Memory 22067167232
Last Notification 1
Timeout 6
Early Termination Factor 5
(5 rows affected)
Small Gateway (default) Value
------------------------------------------------------------------------ -----------
Configured Units 36
Available Units 36
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
(6 rows affected)
Medium Gateway (default) Value
------------------------------------------------------------------------ -----------
Configured Units 9
Available Units 9
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
(6 rows affected)
Big Gateway (default) Value
------------------------------------------------------------------------ -----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
(6 rows affected)
Memory Pool Manager KB
------------------------------------------------------------------------ -----------
Reserved Current 822480
Reserved Limit 27169320
(2 rows affected)
Memory Pool (internal) KB
------------------------------------------------------------------------ -----------
Allocations 1016968
Predicted 1017496
Private Target 0
Private Limit 0
Total Target 29549336
Total Limit 29549336
OOM Count 0
(7 rows affected)
MEMORYBROKER_FOR_CACHE (internal) KB
------------------------------------------------------------------------ -----------
Allocations 209688
Rate 0
Target Allocations 21674064
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_STEAL (internal) KB
------------------------------------------------------------------------ -----------
Allocations 238720
Rate 24
Target Allocations 21703120
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_RESERVE (internal) KB
------------------------------------------------------------------------ -----------
Allocations 0
Rate 0
Target Allocations 21464376
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_COMMITTED (internal) KB
------------------------------------------------------------------------ -----------
Allocations 566360
Rate 504
Target Allocations 22031240
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB
------------------------------------------------------------------------ -----------
Allocations 0
Rate 0
Target Allocations 21464376
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_XTP (internal) KB
------------------------------------------------------------------------ -----------
Allocations 2200
Rate 0
Target Allocations 21466576
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
Memory Pool (default) KB
------------------------------------------------------------------------ -----------
Allocations 2229616
Predicted 7067464
Private Target 0
Private Limit 0
Total Target 29549336
Total Limit 29549336
OOM Count 0
(7 rows affected)
MEMORYBROKER_FOR_CACHE (default) KB
------------------------------------------------------------------------ -----------
Allocations 1289104
Rate -104
Target Allocations 22753480
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_STEAL (default) KB
------------------------------------------------------------------------ -----------
Allocations 73112
Rate 12480
Target Allocations 21549968
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_RESERVE (default) KB
------------------------------------------------------------------------ -----------
Allocations 866568
Rate 234560
Target Allocations 24932248
Future Allocations 5691936
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_HASHED_DATA_PAGES (default) KB
------------------------------------------------------------------------ -----------
Allocations 0
Rate 0
Target Allocations 21464376
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
MEMORYBROKER_FOR_XTP (default) KB
------------------------------------------------------------------------ -----------
Allocations 832
Rate 0
Target Allocations 21465208
Future Allocations 0
Overall 24932248
Last Notification 1
(6 rows affected)
Memory Broker Clerk (Buffer Pool) Pages
------------------------------------------------------------------------ ----------------------
Total 589543
Simulated 0
Simulation Benefit 0
Internal Benefit 0
External Benefit 0
Value Of Memory 0
Periodic Freed 0
Internal Freed 0
(8 rows affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment