SQL server memory issue

M. Elkhodary 1 Reputation point
2021-09-15T12:05:57.187+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2021-09-15T15:12:26.527+00:00

    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://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-memory-usage?view=sql-server-ver15

    0 comments
  2. Erland Sommarskog 100.8K Reputation points MVP
    2021-09-15T22:03:41.94+00:00

    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.

    0 comments
  3. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    2021-09-16T03:30:52.257+00:00

    Hi @M. Elkhodary ,

    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.

    0 comments