question

MElkhodary-7197 avatar image
0 Votes"
MElkhodary-7197 asked Cathyji-msft answered

SQL server memory issue

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

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @MElkhodary-7197,

Did you have SQL server high memory performance issue? If so, suggest you use performance monitor and some DMVs to troubleshoot this issue. Please check if below blogs could help you.

SQL Server monitoring tools for memory performance
TROUBLESHOOTING MEMORY RELATED ISSUES IN MICROSOFT SQL


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

If you are on SQL 2016 or later, enable Query Store, and let it run for a while. Then track down slow queries. Maybe you need more memory. Maybe you just need to tune some queries or add indexes.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

It is completely normal, expected and desired for SQL Server to not release RAM after it has allocated it. This is not an indication of any problem.

If you have not set your "max server memory" to a reasonable setting, it is possible your server is page swapping and causing a performance issue.

Please see:
https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-memory-usage?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.