December 19, 2013 at 6:15 am
Hello fellow MS SQL admins. Did any of you experience a repeated database failure because of failed memory allocation?
Now, let me get to the problem: we are kind of a large eshop, running SQL server 2012 SP1 on a dedicated computer. It has about 144 GB of RAM; the SQL server is configured to take 115 GB max. The data itself is about 150 GB. The computer has page file disabled.
Abount a month ago, the server started acting up, almost completely stopped using memory/caching and started to read all the data directly from disk array. Performance was completelyt shot, od course. After usual checks, we found a dump in the SQL server logs, indicating Failed memory allocation. I am including the log at the end my message, just know it started with "Failed allocate pages: FAIL_PAGE_ALLOCATION 737".
We thought it was a hardware problem and switched to backup SQL in the cluster (they share data). All was swell until a week later, when the same error appeared on the now actively running backup server. The same symptoms, the same error. And a week later the same again. The memory was Ok all the time, 27 GB free, we checked periodically.
Now, I know this is an internal MS SQL error but what can be done to troubleshoot the issue? Can any cumulative update help? Page file settings? Is there a way to monitor if the SQL server has too much memory in execution plans/cache/whatever else?
Thanks for any advice, really. I am at my wit's end.
--------------------------------------------------
Now the server log:
12/11/2013 16:17:58,spid28s,Unknown,Error: 9245<c/> Severity: 16<c/> State: 1.
12/11/2013 16:17:02,spid174,Unknown,Memory Broker Clerk (Buffer Pool) Pages<nl/>---------------------------------------- ----------<nl/>Total 4808155<nl/>Simulated 1202087<nl/>Simulation Benefit 0.0000001948<nl/>Internal Benefit 0<nl/>External Benefit 0<nl/>Value Of Memory 0<nl/>Periodic Freed 0<nl/>Internal Freed 0
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_XTP (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 0<nl/>Rate 0<nl/>Target Allocations 10663055<nl/>Future Allocations 0<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_RESERVE (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 36128<nl/>Rate 35498<nl/>Target Allocations 12779520<nl/>Future Allocations 2968576<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_STEAL (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 22148<nl/>Rate 2836<nl/>Target Allocations 10688039<nl/>Future Allocations 0<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_CACHE (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 1357930<nl/>Rate 6384<nl/>Target Allocations 12027369<nl/>Future Allocations 0<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,Memory Pool (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 1416206<nl/>Predicted 4357874<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 15728641<nl/>Total Limit 15728641<nl/>OOM Count 0
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_XTP (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 2<nl/>Rate 0<nl/>Target Allocations 10663057<nl/>Future Allocations 0<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_COMMITTED (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 546086<nl/>Rate -3<nl/>Target Allocations 11209141<nl/>Future Allocations 0<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_RESERVE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 0<nl/>Rate -58<nl/>Target Allocations 10663055<nl/>Future Allocations 0<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_STEAL (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 42857<nl/>Rate 11<nl/>Target Allocations 10705923<nl/>Future Allocations 0<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,MEMORYBROKER_FOR_CACHE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 118756<nl/>Rate -28<nl/>Target Allocations 10781811<nl/>Future Allocations 0<nl/>Overall 12779520<nl/>Last Notification 1
12/11/2013 16:17:02,spid174,Unknown,Memory Pool (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 707701<nl/>Predicted 707712<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 15728641<nl/>Total Limit 15728641<nl/>OOM Count 0
12/11/2013 16:17:02,spid174,Unknown,Memory Pool Manager Pages<nl/>---------------------------------------- ----------<nl/>Reserved Current 33655<nl/>Reserved Limit 13640862
12/11/2013 16:17:02,spid174,Unknown,Big Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1<nl/>Available Units 1<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 8<nl/>Threshold -1
12/11/2013 16:17:02,spid174,Unknown,Medium Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 24<nl/>Available Units 24<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold 7296367957
12/11/2013 16:17:02,spid174,Unknown,Small Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 96<nl/>Available Units 95<nl/>Acquires 1<nl/>Waiters 0<nl/>Threshold Factor 380000<nl/>Threshold 380000
12/11/2013 16:17:02,spid174,Unknown,Optimization Queue (default) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 104689827840<nl/>Target Memory 87556415488<nl/>Last Notification 1<nl/>Timeout 6<nl/>Early Termination Factor 5
12/11/2013 16:17:02,spid174,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
12/11/2013 16:17:02,spid174,Unknown,Medium Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 24<nl/>Available Units 24<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold -1
12/11/2013 16:17:02,spid174,Unknown,Small Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 96<nl/>Available Units 96<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 380000<nl/>Threshold 380000
12/11/2013 16:17:02,spid174,Unknown,Optimization Queue (internal) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 104689827840<nl/>Target Memory 87702921216<nl/>Last Notification 1<nl/>Timeout 6<nl/>Early Termination Factor 5
12/11/2013 16:17:02,spid174,Unknown,Remote Query Memory Objects (default) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 5937152<nl/>Current Max 5937152
12/11/2013 16:17:02,spid174,Unknown,Small Query Memory Objects (default) Value<nl/>---------------------------------------- ----------<nl/>Grants 17<nl/>Waiting 0<nl/>Available 100696<nl/>Current Max 106496<nl/>Future Max 106496
12/11/2013 16:17:02,spid174,Unknown,Query Memory Objects (default) Value<nl/>---------------------------------------- ----------<nl/>Grants 7<nl/>Waiting 0<nl/>Available 11846321<nl/>Current Max 11874304<nl/>Future Max 11874304<nl/>Physical Max 11874304<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 0
12/11/2013 16:17:02,spid174,Unknown,Remote Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 5937152<nl/>Current Max 5937152
12/11/2013 16:17:02,spid174,Unknown,Small Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 106496<nl/>Current Max 106496<nl/>Future Max 106496
12/11/2013 16:17:02,spid174,Unknown,Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 9890104<nl/>Current Max 9890104<nl/>Future Max 9890104<nl/>Physical Max 11874304<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 0
12/11/2013 16:17:02,spid174,Unknown,Global Memory Objects Pages<nl/>---------------------------------------- ----------<nl/>Resource 578<nl/>Locks 296682<nl/>XDES 3067<nl/>DirtyPageTracking 24<nl/>SETLS 24<nl/>SubpDesc Allocators 24<nl/>SE SchemaManager 2944<nl/>SE Column Metadata Cache 7193<nl/>SE Column Metadata Cache Store 16<nl/>SQLCache 2200<nl/>Replication 2<nl/>ServerGlobal 57<nl/>XP Global 2<nl/>SortTables 36
12/11/2013 16:17:02,spid174,Unknown,Procedure Cache Value<nl/>---------------------------------------- ----------<nl/>TotalProcs 13799<nl/>TotalPages 1009804<nl/>InUsePages 772322
12/11/2013 16:17:02,spid174,Unknown,Buffer Pool Value<nl/>---------------------------------------- ----------<nl/>Database 4808155<nl/>Simulated 1202076<nl/>Target 294699008<nl/>Dirty 70649<nl/>In IO 45<nl/>Latched 14<nl/>Page Life Expectancy 2
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_XACT_CACHE (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/>Pages Allocated 188896
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_XACT_CACHE (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/>Pages Allocated 16
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_XACT_CACHE (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 92632
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_XACT_CACHE (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/>Pages Allocated 96248
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_SECAUDIT_EVENT_BUFFER (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/>Pages Allocated 16
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 526336<nl/>VM Committed 526336<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 2373456
12/11/2013 16:17:02,spid174,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/>Pages Allocated 24
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_LOCK_MANAGER (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 1203664
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_LOCK_MANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 526336<nl/>VM Committed 526336<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 1169768
12/11/2013 16:17:02,spid174,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/>Pages Allocated 202800
12/11/2013 16:17:02,spid174,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/>Pages Allocated 44832
12/11/2013 16:17:02,spid174,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/>Pages Allocated 56
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_SNI_PACKET (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 17240
12/11/2013 16:17:02,spid174,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/>Pages Allocated 27536
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_LBSS (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/>Pages Allocated 17864
12/11/2013 16:17:02,spid174,Unknown,OBJECTSTORE_LBSS (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 9152
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8712
12/11/2013 16:17:02,spid174,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/>Pages Allocated 9040
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,Unknown,USERSTORE_SXC (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 4288
12/11/2013 16:17:02,spid174,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/>Pages Allocated 4744
12/11/2013 16:17:02,spid174,Unknown,USERSTORE_OBJPERM (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/>Pages Allocated 7072
12/11/2013 16:17:02,spid174,Unknown,USERSTORE_OBJPERM (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 800
12/11/2013 16:17:02,spid174,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/>Pages Allocated 6272
12/11/2013 16:17:02,spid174,Unknown,USERSTORE_TOKENPERM (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/>Pages Allocated 479576
12/11/2013 16:17:02,spid174,Unknown,USERSTORE_TOKENPERM (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 21968
12/11/2013 16:17:02,spid174,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/>Pages Allocated 457608
12/11/2013 16:17:02,spid174,Unknown,USERSTORE_DBMETADATA (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/>Pages Allocated 33728
12/11/2013 16:17:02,spid174,Unknown,USERSTORE_DBMETADATA (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 20648
12/11/2013 16:17:02,spid174,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/>Pages Allocated 13080
12/11/2013 16:17:02,spid174,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/>Pages Allocated 81424
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_XML_SELECTIVE_DG (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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_COLUMNSTOREOBJECTPOOL (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/>Pages Allocated 192
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_SEARCHPROPERTYLIST (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/>Pages Allocated 16
12/11/2013 16:17:02,spid174,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/>Pages Allocated 32
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_CONVPRI (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/>Pages Allocated 296
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_CONVPRI (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 16
12/11/2013 16:17:02,spid174,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/>Pages Allocated 280
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_SYSTEMROWSET (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/>Pages Allocated 7192
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_SYSTEMROWSET (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 4376
12/11/2013 16:17:02,spid174,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/>Pages Allocated 2816
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_SEHOBTCOLUMNATTRIBUTE (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/>Pages Allocated 2440
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_CLRPROC (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8
12/11/2013 16:17:02,spid174,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/>Pages Allocated 16
12/11/2013 16:17:02,spid174,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/>Pages Allocated 202224
12/11/2013 16:17:02,spid174,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/>Pages Allocated 37768
12/11/2013 16:17:02,spid174,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/>Pages Allocated 1832
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_BROKERTBLACS (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/>Pages Allocated 13752
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_BROKERTBLACS (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 496
12/11/2013 16:17:02,spid174,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/>Pages Allocated 13256
12/11/2013 16:17:02,spid174,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/>Pages Allocated 24
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,Unknown,CACHESTORE_STACKFRAMES (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8
12/11/2013 16:17:02,spid174,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/>Pages Allocated 32
12/11/2013 16:17:02,spid174,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/>Pages Allocated 272
12/11/2013 16:17:02,spid174,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/>Pages Allocated 6768
12/11/2013 16:17:02,spid174,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/>Pages Allocated 3320
12/11/2013 16:17:02,spid174,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/>Pages Allocated 176
12/11/2013 16:17:02,spid174,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/>Pages Allocated 56992
12/11/2013 16:17:02,spid174,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/>Pages Allocated 1101616
12/11/2013 16:17:02,spid174,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/>Pages Allocated 6918992
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_FSCHUNKER (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/>Pages Allocated 48
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_LWC (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/>Pages Allocated 192
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLLOGPOOL (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/>Pages Allocated 15528
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_HADR (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/>Pages Allocated 24
12/11/2013 16:17:02,spid174,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/>Pages Allocated 4536
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_FILETABLE (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/>Pages Allocated 16
12/11/2013 16:17:02,spid174,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/>Pages Allocated 272
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 576<nl/>SM Committed 576<nl/>Pages Allocated 0
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SOSMEMMANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 545432<nl/>VM Committed 479384<nl/>Locked Pages Allocated 65832<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 0
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SOSOS (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/>Pages Allocated 192
12/11/2013 16:17:02,spid174,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/>Pages Allocated 412040
12/11/2013 16:17:02,spid174,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/>Pages Allocated 2600
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SOSNODE (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 167000
12/11/2013 16:17:02,spid174,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/>Pages Allocated 242440
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_HOST (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 6528
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_XTP (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/>Pages Allocated 16
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_XE_BUFFER (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 4992<nl/>VM Committed 4992<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 0
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_XE_BUFFER (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 1664<nl/>VM Committed 1664<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 0
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_XE_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 3328<nl/>VM Committed 3328<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 0
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLQERESERVATIONS (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/>Pages Allocated 260992
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLQERESERVATIONS (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 94944
12/11/2013 16:17:02,spid174,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/>Pages Allocated 166048
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_BHF (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/>Pages Allocated 632
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_BHF (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 240
12/11/2013 16:17:02,spid174,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/>Pages Allocated 392
12/11/2013 16:17:02,spid174,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/>Pages Allocated 16
12/11/2013 16:17:02,spid174,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/>Pages Allocated 296
12/11/2013 16:17:02,spid174,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/>Pages Allocated 1416
12/11/2013 16:17:02,spid174,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/>Pages Allocated 16
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SNI (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 696
12/11/2013 16:17:02,spid174,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/>Pages Allocated 704
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLHTTP (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8
12/11/2013 16:17:02,spid174,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/>Pages Allocated 5840
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLCLR (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 9465984<nl/>VM Committed 107684<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 60096
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (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/>Pages Allocated 14544
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 6312
12/11/2013 16:17:02,spid174,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/>Pages Allocated 8232
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLSTORENG (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 25472<nl/>VM Committed 0<nl/>Locked Pages Allocated 25472<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 41872
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLSTORENG (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 12568
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLSTORENG (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 25472<nl/>VM Committed 0<nl/>Locked Pages Allocated 25472<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 29304
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLUTILITIES (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/>Pages Allocated 88
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLOPTIMIZER (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/>Pages Allocated 5992
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLOPTIMIZER (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 224
12/11/2013 16:17:02,spid174,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/>Pages Allocated 5768
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLQUERYEXEC (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/>Pages Allocated 13088
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLQUERYEXEC (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 5408
12/11/2013 16:17:02,spid174,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/>Pages Allocated 7680
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLBUFFERPOOL (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 58453012<nl/>VM Committed 262144<nl/>Locked Pages Allocated 2821204<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 38818080
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 8099312
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 58453012<nl/>VM Committed 262144<nl/>Locked Pages Allocated 2821204<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 30718768
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLGENERAL (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/>Pages Allocated 13912
12/11/2013 16:17:02,spid174,Unknown,MEMORYCLERK_SQLGENERAL (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>Pages Allocated 816
12/11/2013 16:17:02,spid174,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/>Pages Allocated 13096
12/11/2013 16:17:02,spid174,Unknown,Memory node Id = 64 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 20<nl/>Locked Pages Allocated 0
12/11/2013 16:17:02,spid174,Unknown,Memory node Id = 1 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 34432<nl/>VM Committed 34452<nl/>Locked Pages Allocated 62879312<nl/>Pages Allocated 16880256<nl/>Pages Free 45999056<nl/>Target Committed 62914552<nl/>Current Committed 62913768<nl/>Foreign Committed 0<nl/>Away Committed 0<nl/>Taken Away Committed 0
12/11/2013 16:17:02,spid174,Unknown,Memory node Id = 0 KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 220131324<nl/>VM Committed 1421712<nl/>Locked Pages Allocated 61492292<nl/>Pages Allocated 34309192<nl/>Pages Free 24270592<nl/>Target Committed 62914552<nl/>Current Committed 62914008<nl/>Foreign Committed 0<nl/>Away Committed 0<nl/>Taken Away Committed 0
12/11/2013 16:17:02,spid174,Unknown,Memory Manager KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 220165820<nl/>VM Committed 1456184<nl/>Locked Pages Allocated 124371604<nl/>Large Pages Allocated 862208<nl/>Emergency Memory 1024<nl/>Emergency Memory In Use 16<nl/>Target Committed 125829128<nl/>Current Committed 125827792<nl/>Pages Allocated 51189488<nl/>Pages Reserved 238576<nl/>Pages Free 70269608<nl/>Pages In Use 16981344<nl/>Page Alloc Potential 102556336<nl/>NUMA Growth Phase 2<nl/>Last OOM Factor 2<nl/>Last OS Error 1314
12/11/2013 16:17:02,spid174,Unknown,Process/System Counts Value<nl/>---------------------------------------- ----------<nl/>Available Physical Memory 16271486976<nl/>Available Virtual Memory 8568761876480<nl/>Available Paging File 13988474880<nl/>Working Set 1166630912<nl/>Percent of Committed Memory in WS 100<nl/>Page Faults 2076724<nl/>System physical memory high 1<nl/>System physical memory low 0<nl/>Process physical memory low 0<nl/>Process virtual memory low 0
12/11/2013 16:17:02,spid174,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 737
December 19, 2013 at 7:04 am
Do you have any of the CU's installed? You might want to check out the documentation for 2012 SP1 CU6. There is an interesting fix noted in this article http://support.microsoft.com/kb/2877100
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 16, 2020 at 4:41 pm
I realize this is a very, very old post but did you ever get this resolved? If so, what steps did you take?
My team just got plagued with the same issue on a server running Microsoft SQL Server 2014 (SP1-GDR) (KB4019091) - 12.0.4237.0 (X64) Jul 5 2017 22:03:42 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 19, 2020 at 8:18 am
The error seemed to be caused by large SQL command via linked server (another SQL server selected a big chunk of data from our SQL server). Once this was eliminated, all these errors have stopped appearing.
Good luck with your problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply