Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Process/System Counts Value
- ---------------------------------------- --------------------
- Available Physical Memory 59720187904
- Available Virtual Memory 8598251843584
- Available Paging File 86066405376
- Working Set 134914818048
- Percent of Committed Memory in WS 100
- Page Faults 34814614
- System physical memory high 1
- System physical memory low 0
- Process physical memory low 0
- Process virtual memory low 0
- (10 row(s) affected)
- Memory Manager KB
- ---------------------------------------- -----------
- VM Reserved 77616648
- VM Committed 17173516
- Locked Pages Allocated 0
- Large Pages Allocated 0
- Emergency Memory 1024
- Emergency Memory In Use 16
- Target Committed 65536008
- Current Committed 17173520
- Pages Allocated 8169152
- Pages Reserved 0
- Pages Free 7970344
- Pages In Use 2834752
- Page Alloc Potential 59424448
- NUMA Growth Phase 0
- Last OOM Factor 0
- Last OS Error 0
- (16 row(s) affected)
- Memory node Id = 0 KB
- ---------------------------------------- -----------
- VM Reserved 77549384
- VM Committed 13953412
- Locked Pages Allocated 0
- Pages Allocated 5110728
- Pages Free 7932848
- Target Committed 32767992
- Current Committed 13953416
- Foreign Committed 71672
- Away Committed 0
- Taken Away Committed 7900640
- (10 row(s) affected)
- Memory node Id = 1 KB
- ---------------------------------------- -----------
- VM Reserved 67200
- VM Committed 3220084
- Locked Pages Allocated 0
- Pages Allocated 3058424
- Pages Free 37496
- Target Committed 32767992
- Current Committed 3220088
- Foreign Committed 0
- Away Committed 7900640
- Taken Away Committed 0
- (10 row(s) affected)
- Memory node Id = 64 KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 20
- Locked Pages Allocated 0
- (3 row(s) affected)
- MEMORYCLERK_SQLGENERAL (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 29664
- (6 row(s) affected)
- MEMORYCLERK_SQLGENERAL (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2184
- (6 row(s) affected)
- MEMORYCLERK_SQLGENERAL (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 31848
- (6 row(s) affected)
- MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 5111696
- VM Committed 414112
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 3997384
- (6 row(s) affected)
- MEMORYCLERK_SQLBUFFERPOOL (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2371000
- (6 row(s) affected)
- MEMORYCLERK_SQLBUFFERPOOL (Total) KB
- ---------------------------------------- -----------
- VM Reserved 5111696
- VM Committed 414112
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 6368384
- (6 row(s) affected)
- MEMORYCLERK_SQLQUERYEXEC (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2048
- (6 row(s) affected)
- MEMORYCLERK_SQLOPTIMIZER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 1824
- (6 row(s) affected)
- MEMORYCLERK_SQLUTILITIES (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 720
- (6 row(s) affected)
- MEMORYCLERK_SQLSTORENG (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 12096
- VM Committed 12096
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 35976
- (6 row(s) affected)
- MEMORYCLERK_SQLSTORENG (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 14320
- (6 row(s) affected)
- MEMORYCLERK_SQLSTORENG (Total) KB
- ---------------------------------------- -----------
- VM Reserved 12096
- VM Committed 12096
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 50296
- (6 row(s) affected)
- MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 6608
- (6 row(s) affected)
- MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 6136
- (6 row(s) affected)
- MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 12744
- (6 row(s) affected)
- MEMORYCLERK_SQLCLR (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 6301440
- VM Committed 7400
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 40688
- (6 row(s) affected)
- MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2208
- (6 row(s) 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 row(s) affected)
- MEMORYCLERK_SQLSERVICEBROKER (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2224
- (6 row(s) 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 row(s) affected)
- MEMORYCLERK_SNI (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 288
- (6 row(s) affected)
- MEMORYCLERK_SNI (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 304
- (6 row(s) 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 row(s) affected)
- MEMORYCLERK_SNI (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 608
- (6 row(s) 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 row(s) 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 row(s) affected)
- MEMORYCLERK_BHF (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 64
- (6 row(s) affected)
- MEMORYCLERK_BHF (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 96
- (6 row(s) affected)
- MEMORYCLERK_BHF (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 160
- (6 row(s) affected)
- MEMORYCLERK_XE_BUFFER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 134400
- VM Committed 134400
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 0
- (6 row(s) affected)
- MEMORYCLERK_XE_BUFFER (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 67200
- VM Committed 67200
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 0
- (6 row(s) affected)
- MEMORYCLERK_XE_BUFFER (Total) KB
- ---------------------------------------- -----------
- VM Reserved 201600
- VM Committed 201600
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 0
- (6 row(s) affected)
- MEMORYCLERK_XTP (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 16
- (6 row(s) affected)
- MEMORYCLERK_HOST (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 152
- (6 row(s) affected)
- MEMORYCLERK_SOSNODE (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 52504
- (6 row(s) affected)
- MEMORYCLERK_SOSNODE (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 23968
- (6 row(s) affected)
- MEMORYCLERK_SOSNODE (node 64) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2488
- (6 row(s) affected)
- MEMORYCLERK_SOSNODE (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 78960
- (6 row(s) affected)
- MEMORYCLERK_SOSOS (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 192
- (6 row(s) affected)
- MEMORYCLERK_SOSMEMMANAGER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 126504
- VM Committed 126304
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 0
- (6 row(s) affected)
- MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
- ---------------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 200
- (6 row(s) affected)
- MEMORYCLERK_FILETABLE (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 16
- (6 row(s) affected)
- MEMORYCLERK_XE (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 1296
- (6 row(s) affected)
- MEMORYCLERK_SQLLOGPOOL (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 25712
- (6 row(s) affected)
- MEMORYCLERK_LWC (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 128
- (6 row(s) 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 row(s) affected)
- CACHESTORE_OBJCP (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 760016
- (6 row(s) affected)
- CACHESTORE_SQLCP (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 305288
- (6 row(s) affected)
- CACHESTORE_PHDR (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 203488
- (6 row(s) affected)
- CACHESTORE_XPROC (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 136
- (6 row(s) affected)
- CACHESTORE_TEMPTABLES (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 248
- (6 row(s) 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 row(s) 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 row(s) 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 row(s) 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 row(s) 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 row(s) 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 row(s) 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 row(s) 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 row(s) 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 row(s) affected)
- CACHESTORE_BROKERTBLACS (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 1992
- (6 row(s) affected)
- CACHESTORE_BROKERTBLACS (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 752
- (6 row(s) affected)
- CACHESTORE_BROKERTBLACS (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2744
- (6 row(s) 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 row(s) 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 row(s) 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 row(s) 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 row(s) affected)
- CACHESTORE_BROKERREADONLY (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 32
- (6 row(s) 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 row(s) 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 row(s) affected)
- CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
- ----------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2944
- (6 row(s) affected)
- CACHESTORE_SYSTEMROWSET (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 16784
- (6 row(s) affected)
- CACHESTORE_SYSTEMROWSET (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 1232
- (6 row(s) affected)
- CACHESTORE_SYSTEMROWSET (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 18016
- (6 row(s) affected)
- CACHESTORE_CONVPRI (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 1168
- (6 row(s) 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 row(s) affected)
- CACHESTORE_CONVPRI (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 1184
- (6 row(s) 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 row(s) 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 row(s) affected)
- CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
- ----------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 128
- (6 row(s) 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 row(s) affected)
- USERSTORE_SCHEMAMGR (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 149192
- (6 row(s) affected)
- USERSTORE_DBMETADATA (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 44840
- (6 row(s) affected)
- USERSTORE_DBMETADATA (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 5496
- (6 row(s) affected)
- USERSTORE_DBMETADATA (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 50336
- (6 row(s) affected)
- USERSTORE_TOKENPERM (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 4304
- (6 row(s) affected)
- USERSTORE_TOKENPERM (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2376
- (6 row(s) affected)
- USERSTORE_TOKENPERM (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 6680
- (6 row(s) affected)
- USERSTORE_OBJPERM (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 11024
- (6 row(s) affected)
- USERSTORE_OBJPERM (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 544
- (6 row(s) affected)
- USERSTORE_OBJPERM (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 11568
- (6 row(s) affected)
- USERSTORE_SXC (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2064
- (6 row(s) affected)
- USERSTORE_SXC (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2112
- (6 row(s) 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 row(s) affected)
- USERSTORE_SXC (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 4184
- (6 row(s) affected)
- OBJECTSTORE_LBSS (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 1080
- (6 row(s) affected)
- OBJECTSTORE_LBSS (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 1072
- (6 row(s) affected)
- OBJECTSTORE_LBSS (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 2152
- (6 row(s) 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 7256
- (6 row(s) 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 7512
- (6 row(s) 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 56
- (6 row(s) affected)
- OBJECTSTORE_SNI_PACKET (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 14824
- (6 row(s) 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 368
- (6 row(s) 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 row(s) affected)
- OBJECTSTORE_SERVICE_BROKER (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 496
- (6 row(s) affected)
- OBJECTSTORE_LOCK_MANAGER (node 0) KB
- ---------------------------------------- -----------
- VM Reserved 262144
- VM Committed 262144
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 4168
- (6 row(s) 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 7832
- (6 row(s) 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 row(s) affected)
- OBJECTSTORE_LOCK_MANAGER (Total) KB
- ---------------------------------------- -----------
- VM Reserved 262144
- VM Committed 262144
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 12024
- (6 row(s) 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 row(s) 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 336
- (6 row(s) affected)
- OBJECTSTORE_XACT_CACHE (node 1) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 200
- (6 row(s) affected)
- OBJECTSTORE_XACT_CACHE (node 64) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 16
- (6 row(s) affected)
- OBJECTSTORE_XACT_CACHE (Total) KB
- ---------------------------------------- -----------
- VM Reserved 0
- VM Committed 0
- Locked Pages Allocated 0
- SM Reserved 0
- SM Committed 0
- Pages Allocated 552
- (6 row(s) affected)
- Buffer Pool Value
- ---------------------------------------- -----------
- Database 796037
- Simulated 0
- Target 8388608
- Dirty 89324
- In IO 0
- Latched 0
- Page Life Expectancy 8676
- (7 row(s) affected)
- Procedure Cache Value
- ---------------------------------------- -----------
- TotalProcs 4849
- TotalPages 158616
- InUsePages 72
- (3 row(s) affected)
- Global Memory Objects Pages
- ---------------------------------------- -----------
- Resource 801
- Locks 1503
- XDES 598
- DirtyPageTracking 16
- SETLS 16
- SubpDesc Allocators 16
- SE SchemaManager 3242
- SE Column Metadata Cache 15406
- SE Column Metadata Cache Store 22
- SQLCache 685
- Replication 2
- ServerGlobal 54
- XP Global 2
- SortTables 3
- (14 row(s) affected)
- Query Memory Objects (internal) Value
- ---------------------------------------- -----------
- Grants 0
- Waiting 0
- Available 6149888
- Current Max 6149888
- Future Max 6149888
- Physical Max 6149888
- Next Request 0
- Waiting For 0
- Cost 0
- Timeout 0
- Wait Time 0
- (11 row(s) affected)
- Small Query Memory Objects (internal) Value
- ---------------------------------------- -----------
- Grants 0
- Waiting 0
- Available 90112
- Current Max 90112
- Future Max 90112
- (5 row(s) affected)
- Remote Query Memory Objects (internal) Value
- ---------------------------------------- -----------
- Grants 0
- Waiting 0
- Available 3074944
- Current Max 3074944
- (4 row(s) affected)
- Optimization Queue (internal) Value
- ---------------------------------------- --------------------
- Overall Memory 54525952000
- Target Memory 51845120000
- Last Notification 1
- Timeout 6
- Early Termination Factor 5
- (5 row(s) affected)
- Small Gateway (internal) Value
- ---------------------------------------- -----------
- Configured Units 64
- Available Units 64
- Acquires 0
- Waiters 0
- Threshold Factor 380000
- Threshold 380000
- (6 row(s) affected)
- Medium Gateway (internal) Value
- ---------------------------------------- -----------
- Configured Units 16
- Available Units 16
- Acquires 0
- Waiters 0
- Threshold Factor 12
- Threshold -1
- (6 row(s) affected)
- Big Gateway (internal) Value
- ---------------------------------------- -----------
- Configured Units 1
- Available Units 1
- Acquires 0
- Waiters 0
- Threshold Factor 8
- Threshold -1
- (6 row(s) affected)
- Memory Pool Manager Pages
- ---------------------------------------- -----------
- Reserved Current 0
- Reserved Limit 7838193
- (2 row(s) affected)
- Memory Pool (internal) Pages
- ---------------------------------------- -----------
- Allocations 353808
- Predicted 1891283
- Private Target 0
- Private Limit 0
- Total Target 8192001
- Total Limit 8192001
- OOM Count 0
- (7 row(s) affected)
- MEMORYBROKER_FOR_CACHE (internal) Pages
- ---------------------------------------- -----------
- Allocations 196521
- Rate -3
- Target Allocations 6497239
- Future Allocations 0
- Overall 6656000
- Last Notification 1
- (6 row(s) affected)
- MEMORYBROKER_FOR_STEAL (internal) Pages
- ---------------------------------------- -----------
- Allocations 28032
- Rate -27
- Target Allocations 6328750
- Future Allocations 0
- Overall 6656000
- Last Notification 1
- (6 row(s) affected)
- MEMORYBROKER_FOR_RESERVE (internal) Pages
- ---------------------------------------- -----------
- Allocations 0
- Rate -119
- Target Allocations 6656000
- Future Allocations 1537472
- Overall 6656000
- Last Notification 1
- (6 row(s) affected)
- MEMORYBROKER_FOR_COMMITTED (internal) Pages
- ---------------------------------------- -----------
- Allocations 129253
- Rate 3
- Target Allocations 6429974
- Future Allocations 0
- Overall 6656000
- Last Notification 1
- (6 row(s) affected)
- MEMORYBROKER_FOR_XTP (internal) Pages
- ---------------------------------------- -----------
- Allocations 2
- Rate 0
- Target Allocations 6300720
- Future Allocations 0
- Overall 6656000
- Last Notification 1
- (6 row(s) affected)
- Memory Broker Clerk (Buffer Pool) Pages
- ---------------------------------------- ----------------------
- Total 796037
- Simulated 0
- Simulation Benefit 0
- Internal Benefit 0
- External Benefit 0
- Value Of Memory 0
- Periodic Freed 0
- Internal Freed 0
- (8 row(s) affected)
- DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement