Failed allocate pages

  • 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

  • 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

  • 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

  • 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