Failed allocate pages

  • Jakub.Janda

    Ten Centuries

    Points: 1358

    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

  • David Benoit

    SSC-Dedicated

    Points: 34562

    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

  • MyDoggieJessie

    SSC-Forever

    Points: 44281

    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

  • Jakub.Janda

    Ten Centuries

    Points: 1358

    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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply