I been facing a problem with my DB . it slows down every day at least 3 times. I checked all SQL server Jobs and Windows tasks to look for something running affecting my DB, but there is nothing running at those times. Also, the error times don't repeat every day at the same time exactly, ex : yesterday 10:15 AM, today 10:35 AM
I also noted that my DB server began to consume more memory. It reaches 84% during work hours. I need your help to understand the output of DBCC MEMORYSTATUS()
Please help me to understand if I really need to upgrade the server memory or no
Process/System Counts Value
Available Physical Memory 11144826880
Available Virtual Memory 140593622540288
Available Paging File 18884440064
Working Set 54827311104
Percent of Committed Memory in WS 100
Page Faults 15808192
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 0
Memory Manager KB
VM Reserved 137948960
VM Committed 53367900
Locked Pages Allocated 0
Large Pages Allocated 0
Emergency Memory 1024
Emergency Memory In Use 16
Target Committed 61228088
Current Committed 53367904
Pages Allocated 29511120
Pages Reserved 1235048
Pages Free 22539384
Pages In Use 9247176
Page Alloc Potential 54072984
NUMA Growth Phase 0
Last OOM Factor 0
Last OS Error 0
Memory node Id = 0 KB
VM Reserved 137828048
VM Committed 22764616
Locked Pages Allocated 0
Pages Allocated 15186168
Pages Free 6688784
Target Committed 30614024
Current Committed 22764616
Foreign Committed 192
Away Committed 14477716
Taken Away Committed 0
Memory node Id = 1 KB
VM Reserved 120720
VM Committed 30603248
Locked Pages Allocated 0
Pages Allocated 14324952
Pages Free 15850600
Target Committed 30614024
Current Committed 30603248
Foreign Committed 139808
Away Committed 0
Taken Away Committed 14477716
Memory node Id = 64 KB
VM Reserved 0
VM Committed 36
Locked Pages Allocated 0
MEMORYCLERK_SQLGENERAL (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 6168
MEMORYCLERK_SQLGENERAL (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
MEMORYCLERK_SQLGENERAL (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 728
MEMORYCLERK_SQLGENERAL (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 144
MEMORYCLERK_SQLGENERAL (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 7064
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
VM Reserved 51708244
VM Committed 755036
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12077960
MEMORYCLERK_SQLBUFFERPOOL (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 10742704
MEMORYCLERK_SQLBUFFERPOOL (Total) KB
VM Reserved 51708244
VM Committed 755036
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 22820664
MEMORYCLERK_SQLQUERYEXEC (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 30992
MEMORYCLERK_SQLQUERYEXEC (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3368
MEMORYCLERK_SQLQUERYEXEC (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64
MEMORYCLERK_SQLQUERYEXEC (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64
MEMORYCLERK_SQLQUERYEXEC (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 34488
MEMORYCLERK_SQLOPTIMIZER (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1696
MEMORYCLERK_QUERYDISKSTORE (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 144
MEMORYCLERK_QUERYDISKSTORE_HASHMAP (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 160
MEMORYCLERK_SQLUTILITIES (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 144
MEMORYCLERK_SQLUTILITIES (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 160
MEMORYCLERK_SQLSTORENG (node 0) KB
VM Reserved 49536
VM Committed 49536
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40232
MEMORYCLERK_SQLSTORENG (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3784
MEMORYCLERK_SQLSTORENG (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 11664
MEMORYCLERK_SQLSTORENG (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8704
MEMORYCLERK_SQLSTORENG (Total) KB
VM Reserved 49536
VM Committed 49536
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64384
MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1280
MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 888
MEMORYCLERK_SQLCONNECTIONPOOL (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 992
MEMORYCLERK_SQLCONNECTIONPOOL (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1352
MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4512
MEMORYCLERK_SQLCLR (node 0) KB
VM Reserved 18898560
VM Committed 19876
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 127080
MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 592
MEMORYCLERK_SQLSERVICEBROKER (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
MEMORYCLERK_SQLSERVICEBROKER (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 608
MEMORYCLERK_SQLHTTP (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
MEMORYCLERK_SNI (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 88
MEMORYCLERK_SNI (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 104
MEMORYCLERK_SNI (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 88
MEMORYCLERK_SNI (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 88
MEMORYCLERK_SNI (node 64) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
MEMORYCLERK_SNI (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 384
MEMORYCLERK_FULLTEXT (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 296
MEMORYCLERK_SQLXP (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
MEMORYCLERK_BHF (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48
MEMORYCLERK_BHF (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64
MEMORYCLERK_BHF (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 144
MEMORYCLERK_BHF (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
MEMORYCLERK_BHF (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 288
MEMORYCLERK_SQLQERESERVATIONS (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1460632
MEMORYCLERK_XE_BUFFER (node 0) KB
VM Reserved 4352
VM Committed 4352
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
MEMORYCLERK_XE_BUFFER (node 1) KB
VM Reserved 4352
VM Committed 4352
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
MEMORYCLERK_XE_BUFFER (node 2) KB
VM Reserved 4352
VM Committed 4352
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
MEMORYCLERK_XE_BUFFER (Total) KB
VM Reserved 13056
VM Committed 13056
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
MEMORYCLERK_SQLTRACE (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2680
MEMORYCLERK_SQLTRACE (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 96
MEMORYCLERK_SQLTRACE (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
MEMORYCLERK_SQLTRACE (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
MEMORYCLERK_SQLTRACE (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2864
MEMORYCLERK_XTP (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 6112
MEMORYCLERK_CSILOBCOMPRESSION (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 384
MEMORYCLERK_HOST (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1088
MEMORYCLERK_SOSNODE (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80696
MEMORYCLERK_SOSNODE (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 54824
MEMORYCLERK_SOSNODE (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 63936
MEMORYCLERK_SOSNODE (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 55640
MEMORYCLERK_SOSNODE (node 64) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3144
MEMORYCLERK_SOSNODE (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 258240
MEMORYCLERK_SOSOS (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 232
MEMORYCLERK_SOSMEMMANAGER (node 0) KB
VM Reserved 213708
VM Committed 212220
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
MEMORYCLERK_FULLTEXT_SHMEM (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 1152
SM Committed 1152
Pages Allocated 0
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 216
MEMORYCLERK_FSAGENT (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
MEMORYCLERK_FILETABLE (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
MEMORYCLERK_XE (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3888
MEMORYCLERK_SPATIAL (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 768
MEMORYCLERK_SQLLOGPOOL (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5760
MEMORYCLERK_LWC (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 384
MEMORYCLERK_FSCHUNKER (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48
CACHESTORE_OBJCP (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 155456
CACHESTORE_SQLCP (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5328080
CACHESTORE_PHDR (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 74352
CACHESTORE_XPROC (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 160
CACHESTORE_TEMPTABLES (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
CACHESTORE_NOTIF (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
CACHESTORE_VIEWDEFINITIONS (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 312
CACHESTORE_XMLDBTYPE (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_XMLDBELEMENT (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_STACKFRAMES (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_STACKFRAMES (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_STACKFRAMES (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_STACKFRAMES (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_STACKFRAMES (node 64) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_STACKFRAMES (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40
CACHESTORE_BROKERTBLACS (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
CACHESTORE_BROKERTBLACS (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 88
CACHESTORE_BROKERTBLACS (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
CACHESTORE_BROKERTBLACS (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 200
CACHESTORE_BROKERKEK (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_BROKERDSH (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_BROKERRSB (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_BROKERREADONLY (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
CACHESTORE_BROKERTO (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
CACHESTORE_EVENTS (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3112
CACHESTORE_SYSTEMROWSET (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32560
CACHESTORE_SYSTEMROWSET (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 14368
CACHESTORE_SYSTEMROWSET (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 46928
CACHESTORE_CONVPRI (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
CACHESTORE_FULLTEXTSTOPLIST (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
CACHESTORE_SEARCHPROPERTYLIST (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1608
CACHESTORE_QDSCONTEXTSETTINGS (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
CACHESTORE_QDSRUNTIMESTATS (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 120
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
USERSTORE_SCHEMAMGR (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 57888
USERSTORE_DBMETADATA (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16664
USERSTORE_DBMETADATA (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 7856
USERSTORE_DBMETADATA (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24520
USERSTORE_TOKENPERM (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1168
USERSTORE_TOKENPERM (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 112
USERSTORE_TOKENPERM (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 128
USERSTORE_TOKENPERM (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
USERSTORE_TOKENPERM (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1464
USERSTORE_OBJPERM (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4704
USERSTORE_OBJPERM (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1176
USERSTORE_OBJPERM (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5880
USERSTORE_SXC (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 248
USERSTORE_SXC (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 288
USERSTORE_SXC (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 280
USERSTORE_SXC (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 248
USERSTORE_SXC (node 64) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
USERSTORE_SXC (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1072
USERSTORE_QDSSTMT (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 176
USERSTORE_QDSSTMT (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
USERSTORE_QDSSTMT (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192
OBJECTSTORE_LBSS (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 536
OBJECTSTORE_LBSS (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 768
OBJECTSTORE_LBSS (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 408
OBJECTSTORE_LBSS (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 392
OBJECTSTORE_LBSS (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2104
OBJECTSTORE_SNI_PACKET (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 10016
OBJECTSTORE_SNI_PACKET (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1984
OBJECTSTORE_SNI_PACKET (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1928
OBJECTSTORE_SNI_PACKET (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1864
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
OBJECTSTORE_SNI_PACKET (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 15848
OBJECTSTORE_SERVICE_BROKER (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 416
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
OBJECTSTORE_SERVICE_BROKER (Total) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 544
OBJECTSTORE_LOCK_MANAGER (node 0) KB
VM Reserved 262148
VM Committed 262148
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 9192
OBJECTSTORE_LOCK_MANAGER (node 1) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12712
OBJECTSTORE_LOCK_MANAGER (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 15216
OBJECTSTORE_LOCK_MANAGER (node 3) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 10248
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
OBJECTSTORE_LOCK_MANAGER (Total) KB
VM Reserved 262148
VM Committed 262148
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 47392
OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 2) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
OBJECTSTORE_XACT_CACHE (node 0) KB
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 26760
Buffer Pool Value
Database 2851848
Simulated 0
Target 7142383
Dirty 1981
In IO 0
Latched 4
Page Life Expectancy 14851
Procedure Cache Value
TotalProcs 81523
TotalPages 694756
InUsePages 1227
Global Memory Objects Pages
Resource 548
Locks 5924
XDES 1073
DirtyPageTracking 2644
SETLS 48
SubpDesc Allocators 48
SE SchemaManager 5179
SE Column Metadata Cache 2056
SE Column Metadata Cache Store 8
SQLCache 4395
Replication 2
ServerGlobal 52
XP Global 2
SortTables 3
Query Memory Objects (internal) Value
Grants 0
Waiting 0
Available 4437427
Current Max 4437427
Future Max 4437427
Physical Max 5595682
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
Small Query Memory Objects (internal) Value
Grants 0
Waiting 0
Available 155648
Current Max 155648
Future Max 155648
Query Memory Objects (default) Value
Grants 1
Waiting 0
Available 5413103
Current Max 5595682
Future Max 5595682
Physical Max 5595682
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
Small Query Memory Objects (default) Value
Grants 0
Waiting 0
Available 155648
Current Max 155648
Future Max 155648
Optimization Queue (internal) Value
Overall Memory 50256011264
Target Memory 40385978368
Last Notification 1
Timeout 6
Early Termination Factor 5
Small Gateway (internal) Value
Configured Units 160
Available Units 160
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
Medium Gateway (internal) Value
Configured Units 40
Available Units 40
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
Big Gateway (internal) Value
Configured Units 2
Available Units 2
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
Optimization Queue (default) Value
Overall Memory 50256011264
Target Memory 40405483520
Last Notification 1
Timeout 6
Early Termination Factor 5
Small Gateway (default) Value
Configured Units 160
Available Units 160
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
Medium Gateway (default) Value
Configured Units 40
Available Units 40
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
Big Gateway (default) Value
Configured Units 2
Available Units 2
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
Memory Pool Manager KB
Reserved Current 1460632
Reserved Limit 50385632
Memory Pool (internal) KB
Allocations 1640952
Predicted 1640952
Private Target 0
Private Limit 0
Total Target 58166680
Total Limit 58166680
OOM Count 0
MEMORYBROKER_FOR_CACHE (internal) KB
Allocations 73216
Rate 0
Target Allocations 39267488
Future Allocations 0
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_STEAL (internal) KB
Allocations 245160
Rate 0
Target Allocations 39439432
Future Allocations 0
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_RESERVE (internal) KB
Allocations 0
Rate 0
Target Allocations 39194272
Future Allocations 0
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_COMMITTED (internal) KB
Allocations 1317400
Rate 0
Target Allocations 40511672
Future Allocations 0
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB
Allocations 0
Rate 0
Target Allocations 39194272
Future Allocations 0
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_XTP (internal) KB
Allocations 5176
Rate 0
Target Allocations 39199448
Future Allocations 0
Overall 49078136
Last Notification 1
Memory Pool (default) KB
Allocations 7600728
Predicted 17331456
Private Target 0
Private Limit 0
Total Target 58166680
Total Limit 58166680
OOM Count 0
MEMORYBROKER_FOR_CACHE (default) KB
Allocations 5874664
Rate -27968
Target Allocations 45068936
Future Allocations 0
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_STEAL (default) KB
Allocations 264208
Rate -7112
Target Allocations 39458480
Future Allocations 0
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_RESERVE (default) KB
Allocations 1460632
Rate 54120
Target Allocations 49078136
Future Allocations 11191360
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_HASHED_DATA_PAGES (default) KB
Allocations 0
Rate 0
Target Allocations 39194272
Future Allocations 0
Overall 49078136
Last Notification 1
MEMORYBROKER_FOR_XTP (default) KB
Allocations 1224
Rate 0
Target Allocations 39195496
Future Allocations 0
Overall 49078136
Last Notification 1
Memory Broker Clerk (Column store object pool) Pages
Total 201
Simulated 0
Simulation Benefit 0
Internal Benefit 0
External Benefit 0
Value Of Memory 0
Periodic Freed 0
Internal Freed 0
Memory Broker Clerk (Buffer Pool) Pages
Total 2851848
Simulated 0
Simulation Benefit 0
Internal Benefit 0
External Benefit 0
Value Of Memory 0
Periodic Freed 0
Internal Freed 0