asked on

SQL Server 2014 - There is insufficient system memory in resource pool 'default' to run this query.

Hello Experts,

I moved from a SQL Server 2008 running on Windows Server 2008 to SQL Server 2014 running on Windows 2012 R2. To make the upgrade, I backed up the databases, Ftp'd to new server, then restored databases. After restore, I checked DB integrity, Reorganized and Rebuilt the indexes, and updated the statistics. The restoration was successful.

On the old server, everything ran fine. I am now receiving out of memory errors (Error ID 701). On the old server I had 32 GB of RAM, on the new server it is 64GB of RAM. Not sure what is causing this - perhaps one of my settings? I am looking for guidance to better troubleshoot this issue. I have plenty of physical memory, is this an issue with virtual memory within SQL?

I ran DBCC Memory Status:

Process/System Counts Value
---------------------------------------- --------------------
Available Physical Memory 62680309760
Available Virtual Memory 34942976
Available Paging File 87069540352
Working Set 3775660032
Percent of Committed Memory in WS 100
Page Faults 7221400
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 1

(10 row(s) affected)

Memory Manager KB
---------------------------------------- -----------
VM Reserved 3781264
VM Committed 3612612
AWE Allocated 0
Large Pages Allocated 0
Emergency Memory 1024
Emergency Memory In Use 16
Target Committed 3616688
Current Committed 3612616
Pages Allocated 363384
Pages Reserved 2480
Pages Free 3154464
Pages In Use 384536
Page Alloc Potential 2996920
NUMA Growth Phase 2
Last OOM Factor 2
Last OS Error 8

(16 row(s) affected)

Memory node Id = 0 KB
---------------------------------------- -----------
VM Reserved 3770376
VM Committed 1807964
AWE Allocated 0
Pages Allocated 215864
Pages Free 1524464
Target Committed 1808336
Current Committed 1807968
Foreign Committed 48
Away Committed 0
Taken Away Committed 0

(10 row(s) affected)

Memory node Id = 1 KB
---------------------------------------- -----------
VM Reserved 10824
VM Committed 1804636
AWE Allocated 0
Pages Allocated 147520
Pages Free 1630000
Target Committed 1808336
Current Committed 1804640
Foreign Committed 0
Away Committed 0
Taken Away Committed 0

(10 row(s) affected)

Memory node Id = 32 KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 12
AWE Allocated 0

(3 row(s) affected)

MEMORYCLERK_SQLGENERAL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 25584

(6 row(s) affected)

MEMORYCLERK_SQLGENERAL (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1168

(6 row(s) affected)

MEMORYCLERK_SQLGENERAL (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 26752

(6 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 64708
VM Committed 52616
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 38040

(6 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 38064

(6 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (Total) KB
---------------------------------------- -----------
VM Reserved 64708
VM Committed 52616
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 76104

(6 row(s) affected)

MEMORYCLERK_SQLQUERYEXEC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24

(6 row(s) affected)

MEMORYCLERK_SQLQUERYEXEC (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 208

(6 row(s) affected)

MEMORYCLERK_SQLQUERYEXEC (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 232

(6 row(s) affected)

MEMORYCLERK_SQLOPTIMIZER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8584

(6 row(s) affected)

MEMORYCLERK_SQLOPTIMIZER (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 296

(6 row(s) affected)

MEMORYCLERK_SQLOPTIMIZER (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8880

(6 row(s) affected)

MEMORYCLERK_QUERYDISKSTORE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 6488

(6 row(s) affected)

MEMORYCLERK_SQLUTILITIES (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1184

(6 row(s) affected)

MEMORYCLERK_SQLUTILITIES (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

MEMORYCLERK_SQLUTILITIES (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1200

(6 row(s) affected)

MEMORYCLERK_SQLSTORENG (node 0) KB
---------------------------------------- -----------
VM Reserved 22080
VM Committed 22080
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 36936

(6 row(s) affected)

MEMORYCLERK_SQLSTORENG (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 11544

(6 row(s) affected)

MEMORYCLERK_SQLSTORENG (Total) KB
---------------------------------------- -----------
VM Reserved 22080
VM Committed 22080
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48480

(6 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4880

(6 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4408

(6 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 9288

(6 row(s) affected)

MEMORYCLERK_SQLCLR (node 0) KB
---------------------------------------- -----------
VM Reserved 100224
VM Committed 884
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1584

(6 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1520

(6 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1536

(6 row(s) affected)

MEMORYCLERK_SQLHTTP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 256

(6 row(s) affected)

MEMORYCLERK_SNI (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 240

(6 row(s) affected)

MEMORYCLERK_SNI (node 32) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 512

(6 row(s) affected)

MEMORYCLERK_FULLTEXT (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 160

(6 row(s) affected)

MEMORYCLERK_SQLXP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2088

(6 row(s) affected)

MEMORYCLERK_BHF (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2112

(6 row(s) affected)

MEMORYCLERK_BHF (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4200

(6 row(s) affected)

MEMORYCLERK_SQLQERESERVATIONS (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2688

(6 row(s) affected)

MEMORYCLERK_XE_BUFFER (node 0) KB
---------------------------------------- -----------
VM Reserved 3072
VM Committed 3072
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_XE_BUFFER (node 1) KB
---------------------------------------- -----------
VM Reserved 1536
VM Committed 1536
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_XE_BUFFER (Total) KB
---------------------------------------- -----------
VM Reserved 4608
VM Committed 4608
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_HOST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56

(6 row(s) affected)

MEMORYCLERK_SOSNODE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 25376

(6 row(s) affected)

MEMORYCLERK_SOSNODE (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 11040

(6 row(s) affected)

MEMORYCLERK_SOSNODE (node 32) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1640

(6 row(s) affected)

MEMORYCLERK_SOSNODE (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 38056

(6 row(s) affected)

MEMORYCLERK_SOSOS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 152

(6 row(s) affected)

MEMORYCLERK_SOSMEMMANAGER (node 0) KB
---------------------------------------- -----------
VM Reserved 4928
VM Committed 4760
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 288
SM Committed 288
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
---------------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 128

(6 row(s) affected)

MEMORYCLERK_XE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2232

(6 row(s) affected)

MEMORYCLERK_SQLLOGPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1368

(6 row(s) affected)

MEMORYCLERK_LWC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 96

(6 row(s) affected)

MEMORYCLERK_FSCHUNKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40

(6 row(s) affected)

CACHESTORE_OBJCP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2320

(6 row(s) affected)

CACHESTORE_SQLCP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 432

(6 row(s) affected)

CACHESTORE_PHDR (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1480

(6 row(s) affected)

CACHESTORE_XPROC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_TEMPTABLES (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_NOTIF (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE 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
AWE 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
AWE 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
AWE 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
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_STACKFRAMES (node 32) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24

(6 row(s) affected)

CACHESTORE_BROKERTBLACS (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_BROKERTBLACS (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40

(6 row(s) affected)

CACHESTORE_BROKERKEK (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE 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
AWE 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
AWE 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
AWE 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
AWE 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
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1440

(6 row(s) affected)

CACHESTORE_SYSTEMROWSET (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1832

(6 row(s) affected)

CACHESTORE_SYSTEMROWSET (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 504

(6 row(s) affected)

CACHESTORE_SYSTEMROWSET (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2336

(6 row(s) affected)

CACHESTORE_CONVPRI (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_CONVPRI (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32

(6 row(s) affected)

CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48

(6 row(s) affected)

CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 96

(6 row(s) affected)

CACHESTORE_XML_SELECTIVE_DG (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 46064

(6 row(s) affected)

USERSTORE_DBMETADATA (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4264

(6 row(s) affected)

USERSTORE_DBMETADATA (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1192

(6 row(s) affected)

USERSTORE_DBMETADATA (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5456

(6 row(s) affected)

USERSTORE_TOKENPERM (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 7584

(6 row(s) affected)

USERSTORE_TOKENPERM (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3480

(6 row(s) affected)

USERSTORE_TOKENPERM (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 11064

(6 row(s) affected)

USERSTORE_OBJPERM (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12064

(6 row(s) affected)

USERSTORE_OBJPERM (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3016

(6 row(s) affected)

USERSTORE_OBJPERM (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 15080

(6 row(s) affected)

USERSTORE_SXC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1920

(6 row(s) affected)

USERSTORE_SXC (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2000

(6 row(s) affected)

USERSTORE_SXC (node 32) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3928

(6 row(s) affected)

USERSTORE_QDSSTMT (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1840

(6 row(s) affected)

USERSTORE_QDSSTMT (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 432

(6 row(s) affected)

USERSTORE_QDSSTMT (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2272

(6 row(s) affected)

OBJECTSTORE_LBSS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 280

(6 row(s) affected)

OBJECTSTORE_LBSS (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 288

(6 row(s) affected)

OBJECTSTORE_LBSS (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 568

(6 row(s) affected)

OBJECTSTORE_SNI_PACKET (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 6320

(6 row(s) affected)

OBJECTSTORE_SNI_PACKET (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 6552

(6 row(s) affected)

OBJECTSTORE_SNI_PACKET (node 32) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 12928

(6 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 384

(6 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 160

(6 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 544

(6 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (node 0) KB
---------------------------------------- -----------
VM Reserved 8192
VM Committed 8192
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 19608

(6 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 9784

(6 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (node 32) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24

(6 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (Total) KB
---------------------------------------- -----------
VM Reserved 8192
VM Committed 8192
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 29416

(6 row(s) affected)

OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
------------------------------------------ -----------
VM Reserved 0
VM Committed 0
AWE 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
AWE Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 304

(6 row(s) affected)

Buffer Pool Value
---------------------------------------- -----------
Database 9103
Simulated 2215
Target 524288
Dirty 707
In IO 199
Latched 60
Page Life Expectancy 1

(7 row(s) affected)

Procedure Cache Value
---------------------------------------- -----------
TotalProcs 7
TotalPages 368
InUsePages 67

(3 row(s) affected)

Global Memory Objects Pages
---------------------------------------- -----------
Resource 755
Locks 3677
XDES 622
DirtyPageTracking 12
SETLS 12
SubpDesc Allocators 12
SE SchemaManager 2376
SE Column Metadata Cache 3317
SE Column Metadata Cache Store 6
SQLCache 39
Replication 2
ServerGlobal 32
XP Global 2
SortTables 2

(14 row(s) affected)

Query Memory Objects (internal) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 322734
Current Max 322734
Future Max 322734
Physical Max 322734
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 16986
Current Max 16986
Future Max 16986

(5 row(s) affected)

Remote Query Memory Objects (internal) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 161367
Current Max 161367

(4 row(s) affected)

Query Memory Objects (default) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 322734
Current Max 322734
Future Max 322734
Physical Max 322734
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0

(11 row(s) affected)

Small Query Memory Objects (default) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 16986
Current Max 16986
Future Max 16986

(5 row(s) affected)

Remote Query Memory Objects (default) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 161367
Current Max 161367

(4 row(s) affected)

Optimization Queue (internal) Value
---------------------------------------- --------------------
Overall Memory 2968567808
Target Memory 2968567808
Last Notification 1
Timeout 6
Early Termination Factor 5

(5 row(s) affected)

Small Gateway (internal) Value
---------------------------------------- -----------
Configured Units 32
Available Units 32
Acquires 0
Waiters 0
Threshold Factor 250000
Threshold 250000

(6 row(s) affected)

Medium Gateway (internal) Value
---------------------------------------- -----------
Configured Units 8
Available Units 8
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)

Optimization Queue (default) Value
---------------------------------------- --------------------
Overall Memory 2968567808
Target Memory 2968567808
Last Notification 1
Timeout 6
Early Termination Factor 5

(5 row(s) affected)

Small Gateway (default) Value
---------------------------------------- -----------
Configured Units 32
Available Units 21
Acquires 11
Waiters 0
Threshold Factor 250000
Threshold 250000

(6 row(s) affected)

Medium Gateway (default) Value
---------------------------------------- -----------
Configured Units 8
Available Units 8
Acquires 0
Waiters 0
Threshold Factor 12
Threshold 22489150

(6 row(s) affected)

Big Gateway (default) Value
---------------------------------------- -----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1

(6 row(s) affected)

Memory Pool Manager KB
---------------------------------------- -----------
Reserved Current 0
Reserved Limit 3055960

(2 row(s) affected)

Memory Pool (internal) KB
---------------------------------------- -----------
Allocations 260824
Predicted 260824
Private Target 0
Private Limit 0
Total Target 3435848
Total Limit 3435848
OOM Count 0

(7 row(s) affected)

MEMORYBROKER_FOR_CACHE (internal) KB
---------------------------------------- --------------------
Allocations 59992
Rate 4294966488
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_STEAL (internal) KB
---------------------------------------- --------------------
Allocations 106064
Rate 4294967248
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_RESERVE (internal) KB
---------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_COMMITTED (internal) KB
---------------------------------------- -----------
Allocations 94768
Rate 0
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB
--------------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_XTP (internal) KB
---------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

Memory Pool (default) KB
---------------------------------------- -----------
Allocations 119128
Predicted 119128
Private Target 0
Private Limit 0
Total Target 3435848
Total Limit 3435848
OOM Count 0

(7 row(s) affected)

MEMORYBROKER_FOR_CACHE (default) KB
---------------------------------------- --------------------
Allocations 74248
Rate 4294955312
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_STEAL (default) KB
---------------------------------------- --------------------
Allocations 44880
Rate 4294966680
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_RESERVE (default) KB
---------------------------------------- --------------------
Allocations 0
Rate 4294964944
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_HASHED_DATA_PAGES (default) KB
-------------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_XTP (default) KB
---------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 2898992
Future Allocations 0
Overall 2898992
Last Notification 1

(6 row(s) affected)

Memory Broker Clerk (Buffer Pool) Pages
---------------------------------------- ----------------------
Total 9289
Simulated 2172
Simulation Benefit 0.00199061338289963
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.

JCaracci1

ASKER

Version info:

Microsoft Windows Server 2012 R2 Standard
AMD Opteron Processor
64GB RAM
3724 GB disk space

Microsoft SQL Server 2014 Enterprise - 12.0.2000.8 (Intel X86)

JCaracci1

ASKER

Also tried restarting SQL Service and rebooting server, but still receiving this error after restart and reboot.

ASKER CERTIFIED SOLUTION

JCaracci1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial