February 26, 2016 at 2:15 am
Hi,
More than 3 days i'am getting this error when i run the ETL PROCESS
VERSION :SQL SERVER 2008 R2 (STANDARD EDITION) 64 BIT (WINDOWS 2008)
RAM :14 GB
PLEASE HELP ME .
ERROR DETAILS
============
2/26/2016 08:00:38,Server,Unknown,SQL Server is terminating a system or background task Fulltext Host Controller Timer Task due to errors in starting up the task (setup state 1).
02/26/2016 08:00:38,Server,Unknown,Error: 17312<c/> Severity: 16<c/> State: 1.
02/26/2016 08:00:38,Server,Unknown,SQL Server was unable to run a new system task<c/> either because there is insufficient memory or the number of configured sessions exceeds the maximum allowed in the server. Verify that the server has adequate memory. Use sp_configure with option 'user connections' to check the maximum number of user connections allowed. Use sys.dm_exec_sessions to check the current number of sessions<c/> including user processes.
02/26/2016 08:00:38,Server,Unknown,Error: 17300<c/> Severity: 16<c/> State: 1.
02/26/2016 08:00:38,Logon,Unknown,There was a memory allocation failure during connection establishment. Reduce nonessential memory load<c/> or increase system memory. The connection has been closed. [CLIENT: <local machine>]
02/26/2016 08:00:38,Logon,Unknown,Error: 17803<c/> Severity: 20<c/> State: 13.
02/26/2016 08:00:38,Logon,Unknown,There was a memory allocation failure during connection establishment. Reduce nonessential memory load<c/> or increase system memory. The connection has been closed. [CLIENT: <local machine>]
02/26/2016 08:00:38,Logon,Unknown,Error: 17803<c/> Severity: 20<c/> State: 4.
02/26/2016 08:00:38,spid53,Unknown,There is insufficient system memory in resource pool 'internal' to run this query.
02/26/2016 08:00:38,spid53,Unknown,Error: 701<c/> Severity: 17<c/> State: 130.
02/26/2016 08:00:38,spid52,Unknown,There is insufficient system memory in resource pool 'internal' to run this query.
02/26/2016 08:00:38,spid52,Unknown,Error: 701<c/> Severity: 17<c/> State: 65.
02/26/2016 08:00:38,spid56,Unknown,There is insufficient system memory in resource pool 'internal' to run this query.
02/26/2016 08:00:38,spid56,Unknown,Error: 701<c/> Severity: 17<c/> State: 130.
02/26/2016 08:00:01,spid56,Unknown,MEMORYBROKER_FOR_RESERVE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 535113<nl/>Rate 0<nl/>Target Allocations 1470827<nl/>Future Allocations 328338<nl/>Overall 1470827<nl/>Last Notification 1
02/26/2016 08:00:01,spid56,Unknown,MEMORYBROKER_FOR_STEAL (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 1222<nl/>Rate 6<nl/>Target Allocations 1204782<nl/>Future Allocations 0<nl/>Overall 1470827<nl/>Last Notification 1
02/26/2016 08:00:01,spid56,Unknown,MEMORYBROKER_FOR_CACHE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 3308<nl/>Rate 0<nl/>Target Allocations 1206862<nl/>Future Allocations 0<nl/>Overall 1470827<nl/>Last Notification 1
02/26/2016 08:00:01,spid56,Unknown,Memory Pool (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 539643<nl/>Predicted 539649<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 1743203<nl/>Total Limit 1743203<nl/>OOM Count 0
02/26/2016 08:00:01,spid56,Unknown,Memory Pool Manager Pages<nl/>---------------------------------------- ----------<nl/>Reserved Current 535113<nl/>Reserved Limit 1738673
02/26/2016 08:00:01,spid56,Unknown,Big Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1<nl/>Available Units 1<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 8<nl/>Threshold -1
02/26/2016 08:00:01,spid56,Unknown,Medium Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 2<nl/>Available Units 2<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold -1
02/26/2016 08:00:01,spid56,Unknown,Small Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 8<nl/>Available Units 8<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 380000<nl/>Threshold 380000
02/26/2016 08:00:01,spid56,Unknown,Optimization Queue (internal) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 12049014784<nl/>Target Memory 9869574144<nl/>Last Notification 1<nl/>Timeout 6<nl/>Early Termination Factor 5
02/26/2016 08:00:01,spid56,Unknown,Small Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 1<nl/>Waiting 0<nl/>Available 65340<nl/>Current Max 65536<nl/>Future Max 65536
02/26/2016 08:00:01,spid56,Unknown,Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 1<nl/>Waiting 0<nl/>Available 778437<nl/>Current Max 1313354<nl/>Future Max 1313354<nl/>Physical Max 1313354<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 0
02/26/2016 08:00:01,spid56,Unknown,Global Memory Objects Pages<nl/>---------------------------------------- ----------<nl/>Resource 315<nl/>Locks 925<nl/>XDES 31<nl/>SETLS 2<nl/>SE Dataset Allocators 4<nl/>SubpDesc Allocators 2<nl/>SE SchemaManager 301<nl/>SE Column Metadata Cache 283<nl/>SQLCache 204<nl/>Replication 2<nl/>ServerGlobal 50<nl/>XP Global 2<nl/>SortTables 2
02/26/2016 08:00:01,spid56,Unknown,Procedure Cache Value<nl/>---------------------------------------- ----------<nl/>TotalProcs 57<nl/>TotalPages 1560<nl/>InUsePages 506
02/26/2016 08:00:01,spid56,Unknown,Process/System Counts Value<nl/>---------------------------------------- ----------<nl/>Available Physical Memory 885346304<nl/>Available Virtual Memory 8780682973184<nl/>Available Paging File 17531465728<nl/>Working Set 13489872896<nl/>Percent of Committed Memory in WS 89<nl/>Page Faults 6616355<nl/>System physical memory high 1<nl/>System physical memory low 0<nl/>Process physical memory low 0<nl/>Process virtual memory low 0
02/26/2016 08:00:01,spid56,Unknown,Buffer Pool Value<nl/>---------------------------------------- ----------<nl/>Committed 1792000<nl/>Target 1834951<nl/>Database 1409712<nl/>Dirty 73891<nl/>In IO 0<nl/>Latched 7<nl/>Free 0<nl/>Stolen 382288<nl/>Reserved 157345<nl/>Visible 1834951<nl/>Stolen Potential 1203570<nl/>Limiting Factor 13<nl/>Last OOM Factor 20<nl/>Page Life Expectancy 4294955
02/26/2016 08:00:00,spid56,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 32768<nl/>VM Committed 32768<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 7400<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,OBJECTSTORE_LOCK_MANAGER (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,OBJECTSTORE_LOCK_MANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 32768<nl/>VM Committed 32768<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 7376<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,OBJECTSTORE_SERVICE_BROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 424<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,OBJECTSTORE_SNI_PACKET (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 312<nl/>MultiPage Allocator 112
02/26/2016 08:00:00,spid56,Unknown,OBJECTSTORE_SNI_PACKET (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 56
02/26/2016 08:00:00,spid56,Unknown,OBJECTSTORE_SNI_PACKET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 312<nl/>MultiPage Allocator 56
02/26/2016 08:00:00,spid56,Unknown,OBJECTSTORE_LBSS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 128
02/26/2016 08:00:00,spid56,Unknown,USERSTORE_SXC (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 72<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,USERSTORE_SXC (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,USERSTORE_SXC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 64<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,USERSTORE_OBJPERM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 424<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,USERSTORE_TOKENPERM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 560<nl/>MultiPage Allocator 264
02/26/2016 08:00:00,spid56,Unknown,USERSTORE_DBMETADATA (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 784<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,USERSTORE_SCHEMAMGR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4576<nl/>MultiPage Allocator 104
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_FULLTEXTSTOPLIST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_CONVPRI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 64<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_SYSTEMROWSET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 936<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_EVENTS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_BROKERTO (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_BROKERREADONLY (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_BROKERRSB (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_BROKERDSH (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_BROKERKEK (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_BROKERTBLACS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 56<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_STACKFRAMES (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 16
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_STACKFRAMES (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 8
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_STACKFRAMES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 8
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_XMLDBATTRIBUTE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_XMLDBELEMENT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_XMLDBTYPE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_VIEWDEFINITIONS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_NOTIF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_TEMPTABLES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_XPROC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 40<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_PHDR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 600<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_SQLCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1608<nl/>MultiPage Allocator 1584
02/26/2016 08:00:00,spid56,Unknown,CACHESTORE_OBJCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8384<nl/>MultiPage Allocator 264
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_XE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 112<nl/>MultiPage Allocator 168
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 48<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 48<nl/>SM Committed 48<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SOSNODE (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4584<nl/>MultiPage Allocator 15976
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SOSNODE (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 2336
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SOSNODE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4576<nl/>MultiPage Allocator 13640
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_HOST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_XE_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 4224<nl/>VM Committed 4224<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLQERESERVATIONS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4280904<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_BHF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLXP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_FULLTEXT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SNI (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 32
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SNI (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 16
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SNI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 16
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLHTTP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLSERVICEBROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 160<nl/>MultiPage Allocator 544
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLCLR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 488<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLSTORENG (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 4480<nl/>VM Committed 4480<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 2240<nl/>MultiPage Allocator 4640
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLUTILITIES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 240<nl/>VM Committed 240<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 176<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLOPTIMIZER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 128<nl/>MultiPage Allocator 896
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLQUERYEXEC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 14712832<nl/>VM Committed 14696448<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 400
02/26/2016 08:00:00,spid56,Unknown,MEMORYCLERK_SQLGENERAL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1576<nl/>MultiPage Allocator 4384
02/26/2016 08:00:00,spid56,Unknown,Memory node Id = 64 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 2560<nl/>VM Committed 2504<nl/>Locked Pages Allocated 0<nl/>MultiPage Allocator 2416<nl/>SinglePage Allocator 36160
02/26/2016 08:00:00,spid56,Unknown,Memory node Id = 0 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 14784160<nl/>VM Committed 14765952<nl/>Locked Pages Allocated 0<nl/>MultiPage Allocator 27280<nl/>SinglePage Allocator 36160
02/26/2016 08:00:00,spid56,Unknown,Memory Manager KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 14787808<nl/>VM Committed 14769488<nl/>Locked Pages Allocated 0<nl/>Reserved Memory 1024<nl/>Reserved Memory In Use 0
02/26/2016 08:00:00,spid56,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 1
02/26/2016 07:59:51,spid55,Unknown,MEMORYBROKER_FOR_RESERVE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 535113<nl/>Rate 0<nl/>Target Allocations 1470827<nl/>Future Allocations 328338<nl/>Overall 1470827<nl/>Last Notification 1
02/26/2016 07:59:51,spid55,Unknown,MEMORYBROKER_FOR_STEAL (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 1220<nl/>Rate 0<nl/>Target Allocations 1204782<nl/>Future Allocations 0<nl/>Overall 1470827<nl/>Last Notification 1
02/26/2016 07:59:51,spid55,Unknown,MEMORYBROKER_FOR_CACHE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 3308<nl/>Rate 0<nl/>Target Allocations 1206870<nl/>Future Allocations 0<nl/>Overall 1470827<nl/>Last Notification 1
02/26/2016 07:59:51,spid55,Unknown,Memory Pool (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 539641<nl/>Predicted 539641<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 1743203<nl/>Total Limit 1743203<nl/>OOM Count 0
02/26/2016 07:59:51,spid55,Unknown,Memory Pool Manager Pages<nl/>---------------------------------------- ----------<nl/>Reserved Current 535113<nl/>Reserved Limit 1738675
02/26/2016 07:59:51,spid55,Unknown,Big Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1<nl/>Available Units 1<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 8<nl/>Threshold -1
02/26/2016 07:59:51,spid55,Unknown,Medium Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 2<nl/>Available Units 2<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold -1
02/26/2016 07:59:51,spid55,Unknown,Small Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 8<nl/>Available Units 8<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 380000<nl/>Threshold 380000
02/26/2016 07:59:51,spid55,Unknown,Optimization Queue (internal) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 12049014784<nl/>Target Memory 9869574144<nl/>Last Notification 1<nl/>Timeout 6<nl/>Early Termination Factor 5
02/26/2016 07:59:51,spid55,Unknown,Small Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 1<nl/>Waiting 0<nl/>Available 65340<nl/>Current Max 65536<nl/>Future Max 65536
02/26/2016 07:59:51,spid55,Unknown,Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 1<nl/>Waiting 0<nl/>Available 778437<nl/>Current Max 1313354<nl/>Future Max 1313354<nl/>Physical Max 1313354<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 0
02/26/2016 07:59:51,spid55,Unknown,Global Memory Objects Pages<nl/>---------------------------------------- ----------<nl/>Resource 315<nl/>Locks 925<nl/>XDES 31<nl/>SETLS 2<nl/>SE Dataset Allocators 4<nl/>SubpDesc Allocators 2<nl/>SE SchemaManager 301<nl/>SE Column Metadata Cache 283<nl/>SQLCache 204<nl/>Replication 2<nl/>ServerGlobal 50<nl/>XP Global 2<nl/>SortTables 2
02/26/2016 07:59:51,spid55,Unknown,Procedure Cache Value<nl/>---------------------------------------- ----------<nl/>TotalProcs 57<nl/>TotalPages 1560<nl/>InUsePages 506
02/26/2016 07:59:51,spid55,Unknown,Process/System Counts Value<nl/>---------------------------------------- ----------<nl/>Available Physical Memory 886345728<nl/>Available Virtual Memory 8780682973184<nl/>Available Paging File 17530576896<nl/>Working Set 13489528832<nl/>Percent of Committed Memory in WS 89<nl/>Page Faults 6616261<nl/>System physical memory high 1<nl/>System physical memory low 0<nl/>Process physical memory low 0<nl/>Process virtual memory low 0
02/26/2016 07:59:51,spid55,Unknown,Buffer Pool Value<nl/>---------------------------------------- ----------<nl/>Committed 1792000<nl/>Target 1834951<nl/>Database 1409712<nl/>Dirty 73891<nl/>In IO 0<nl/>Latched 7<nl/>Free 0<nl/>Stolen 382288<nl/>Reserved 157345<nl/>Visible 1834951<nl/>Stolen Potential 1203570<nl/>Limiting Factor 13<nl/>Last OOM Factor 20<nl/>Page Life Expectancy 4294955
02/26/2016 07:59:50,spid55,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 32768<nl/>VM Committed 32768<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 7400<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,OBJECTSTORE_LOCK_MANAGER (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,OBJECTSTORE_LOCK_MANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 32768<nl/>VM Committed 32768<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 7376<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,OBJECTSTORE_SERVICE_BROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 424<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,OBJECTSTORE_SNI_PACKET (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 312<nl/>MultiPage Allocator 112
02/26/2016 07:59:50,spid55,Unknown,OBJECTSTORE_SNI_PACKET (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 56
02/26/2016 07:59:50,spid55,Unknown,OBJECTSTORE_SNI_PACKET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 312<nl/>MultiPage Allocator 56
02/26/2016 07:59:50,spid55,Unknown,OBJECTSTORE_LBSS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 128
02/26/2016 07:59:50,spid55,Unknown,USERSTORE_SXC (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 72<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,USERSTORE_SXC (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,USERSTORE_SXC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 64<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,USERSTORE_OBJPERM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 424<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,USERSTORE_TOKENPERM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 560<nl/>MultiPage Allocator 264
02/26/2016 07:59:50,spid55,Unknown,USERSTORE_DBMETADATA (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 784<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,USERSTORE_SCHEMAMGR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4576<nl/>MultiPage Allocator 104
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_FULLTEXTSTOPLIST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_CONVPRI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 64<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_SYSTEMROWSET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 936<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_EVENTS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_BROKERTO (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_BROKERREADONLY (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_BROKERRSB (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_BROKERDSH (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_BROKERKEK (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_BROKERTBLACS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 56<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_STACKFRAMES (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 16
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_STACKFRAMES (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 8
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_STACKFRAMES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 8
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_XMLDBATTRIBUTE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_XMLDBELEMENT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_XMLDBTYPE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_VIEWDEFINITIONS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_NOTIF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_TEMPTABLES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_XPROC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 40<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_PHDR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 600<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_SQLCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1608<nl/>MultiPage Allocator 1584
02/26/2016 07:59:50,spid55,Unknown,CACHESTORE_OBJCP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8384<nl/>MultiPage Allocator 264
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_XE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 112<nl/>MultiPage Allocator 168
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 48<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 48<nl/>SM Committed 48<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SOSNODE (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4584<nl/>MultiPage Allocator 15976
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SOSNODE (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 2336
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SOSNODE (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4576<nl/>MultiPage Allocator 13640
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_HOST (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_XE_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 4224<nl/>VM Committed 4224<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLQERESERVATIONS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4280904<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_BHF (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLXP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_FULLTEXT (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SNI (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 32
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SNI (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 16
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SNI (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 32<nl/>MultiPage Allocator 16
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLHTTP (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLSERVICEBROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 160<nl/>MultiPage Allocator 544
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLCLR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 8<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 488<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLSTORENG (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 4480<nl/>VM Committed 4480<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 2240<nl/>MultiPage Allocator 4640
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLUTILITIES (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 240<nl/>VM Committed 240<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 176<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLOPTIMIZER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 128<nl/>MultiPage Allocator 896
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLQUERYEXEC (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 14712832<nl/>VM Committed 14696448<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 400
02/26/2016 07:59:50,spid55,Unknown,MEMORYCLERK_SQLGENERAL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1576<nl/>MultiPage Allocator 4384
02/26/2016 07:59:50,spid55,Unknown,Memory node Id = 64 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 2560<nl/>VM Committed 2504<nl/>Locked Pages Allocated 0<nl/>MultiPage Allocator 2416<nl/>SinglePage Allocator 36160
02/26/2016 07:59:50,spid55,Unknown,Memory node Id = 0 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 14784160<nl/>VM Committed 14765952<nl/>Locked Pages Allocated 0<nl/>MultiPage Allocator 27280<nl/>SinglePage Allocator 36160
02/26/2016 07:59:50,spid55,Unknown,Memory Manager KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 14787808<nl/>VM Committed 14769488<nl/>Locked Pages Allocated 0<nl/>Reserved Memory 1024<nl/>Reserved Memory In Use 0
February 26, 2016 at 3:51 am
hi,
In that database auto shrink on also logshipping going on every 15 minutes
February 26, 2016 at 9:37 am
Stop auto shrink. No reason to have that enabled.
The memory issue usually means the system has really experienced memory pressure from the workload. I'd say a reboot is a quick way to see if this is transient or a systemic issue. You might need more memory for the process. Is this SSIS as the ETL? I thought you could tune down the resources that uses.
February 26, 2016 at 1:49 pm
Are you patched?
https://support.microsoft.com/en-us/kb/982854
Extended events and ring buffers have also been causing some memory strife lately...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply