Home Forums SQL Server 2014 Administration - SQL Server 2014 Memory issue .. cloudberry service getting stop with following error RE: Memory issue .. cloudberry service getting stop with following error

  • December 18, 2017 at 9:09 am

    #1972530

    Failed allocate pages: FAIL_PAGE_ALLOCATION 1

    CACHESTORE_XMLDBTYPE (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_XMLDBELEMENT (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_XMLDBATTRIBUTE (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_STACKFRAMES (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_STACKFRAMES (node 64)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_STACKFRAMES (Total)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 16:04    Server
    CACHESTORE_BROKERTBLACS (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            56    
    2017-12-15 16:04    Server
    CACHESTORE_BROKERKEK (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_BROKERDSH (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_BROKERUSERCERTLOOKUP (node 0)   KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_BROKERRSB (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_BROKERREADONLY (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            32    
    2017-12-15 16:04    Server
    CACHESTORE_BROKERTO (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    CACHESTORE_EVENTS (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 16:04    Server
    CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0)   KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            80    
    2017-12-15 16:04    Server
    CACHESTORE_SYSTEMROWSET (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           224    
    2017-12-15 16:04    Server
    CACHESTORE_CONVPRI (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            64    
    2017-12-15 16:04    Server
    CACHESTORE_FULLTEXTSTOPLIST (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            32    
    2017-12-15 16:04    Server
    CACHESTORE_SEARCHPROPERTYLIST (node 0)    KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 16:04    Server
    CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0)   KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            32    
    2017-12-15 16:04    Server
    CACHESTORE_XML_SELECTIVE_DG (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    USERSTORE_SCHEMAMGR (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           2080    
    2017-12-15 16:04    Server
    USERSTORE_DBMETADATA (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           152    
    2017-12-15 16:04    Server
    USERSTORE_TOKENPERM (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           1080    
    2017-12-15 16:04    Server
    USERSTORE_OBJPERM (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           296    
    2017-12-15 16:04    Server
    USERSTORE_SXC (node 0)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            48    
    2017-12-15 16:04    Server
    USERSTORE_SXC (node 64)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 16:04    Server
    USERSTORE_SXC (Total)          KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            56    
    2017-12-15 16:04    Server
    USERSTORE_QDSSTMT (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            64    
    2017-12-15 16:04    Server
    OBJECTSTORE_LBSS (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            48    
    2017-12-15 16:04    Server
    OBJECTSTORE_SNI_PACKET (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           192    
    2017-12-15 16:04    Server
    OBJECTSTORE_SNI_PACKET (node 64)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            56    
    2017-12-15 16:04    Server
    OBJECTSTORE_SNI_PACKET (Total)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           248    
    2017-12-15 16:04    Server
    OBJECTSTORE_SERVICE_BROKER (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           544    
    2017-12-15 16:04    Server
    OBJECTSTORE_LOCK_MANAGER (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved            16384    
    VM Committed            16384    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           808    
    2017-12-15 16:04    Server
    OBJECTSTORE_LOCK_MANAGER (node 64)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            24    
    2017-12-15 16:04    Server
    OBJECTSTORE_LOCK_MANAGER (Total)      KB    
    ---------------------------------------- ----------    
    VM Reserved            16384    
    VM Committed            16384    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           832    
    2017-12-15 16:04    Server
    OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0)   KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 16:04    Server
    OBJECTSTORE_XACT_CACHE (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            64    
    2017-12-15 16:04    Server
    Buffer Pool            Value    
    ---------------------------------------- ----------    
    Database              0    
    Simulated              0    
    Target             32751616    
    Dirty               0    
    In IO               0    
    Latched               0    
    Page Life Expectancy          0    
    2017-12-15 16:04    Server
    Procedure Cache           Value    
    ---------------------------------------- ----------    
    TotalProcs              0    
    TotalPages             210    
    InUsePages              0    
    2017-12-15 16:04    Server
    Global Memory Objects         Pages    
    ---------------------------------------- ----------    
    Resource              395    
    Locks               104    
    XDES               32    
    DirtyPageTracking           4    
    SETLS               4    
    SubpDesc Allocators           4    
    SE SchemaManager           130    
    SE Column Metadata Cache        129    
    SE Column Metadata Cache Store       1    
    SQLCache              202    
    Replication             2    
    ServerGlobal             52    
    XP Global              2    
    SortTables              3    
    2017-12-15 16:04    Server
    Query Memory Objects (internal)     Value    
    ---------------------------------------- ----------    
    Grants               0    
    Waiting               0    
    Available             435    
    Current Max             435    
    Future Max             435    
    Physical Max            14265    
    Next Request             0    
    Waiting For             0    
    Cost                0    
    Timeout               0    
    Wait Time              0    
    2017-12-15 16:04    Server
    Small Query Memory Objects (internal)   Value    
    ---------------------------------------- ----------    
    Grants               0    
    Waiting               0    
    Available              0    
    Current Max             0    
    Future Max              0    
    2017-12-15 16:04    Server
    Remote Query Memory Objects (internal)   Value    
    ---------------------------------------- ----------    
    Grants               0    
    Waiting               0    
    Available             7132    
    Current Max            7132    
    2017-12-15 16:04    Server
    Query Memory Objects (default)      Value    
    ---------------------------------------- ----------    
    Grants               0    
    Waiting               0    
    Available             435    
    Current Max             435    
    Future Max             435    
    Physical Max            14265    
    Next Request             0    
    Waiting For             0    
    Cost                0    
    Timeout               0    
    Wait Time              0    
    2017-12-15 16:04    Server
    Small Query Memory Objects (default)    Value    
    ---------------------------------------- ----------    
    Grants               0    
    Waiting               0    
    Available              0    
    Current Max             0    
    Future Max              0    
    2017-12-15 16:04    Server
    Remote Query Memory Objects (default)   Value    
    ---------------------------------------- ----------    
    Grants               0    
    Waiting               0    
    Available             7132    
    Current Max            7132    
    2017-12-15 16:04    Server
    Optimization Queue (internal)      Value    
    ---------------------------------------- ----------    
    Overall Memory          124682240    
    Target Memory          43270144    
    Last Notification           2    
    Timeout               6    
    Early Termination Factor         5    
    2017-12-15 16:04    Server
    Small Gateway (internal)        Value    
    ---------------------------------------- ----------    
    Configured Units           16    
    Available Units            16    
    Acquires              0    
    Waiters               0    
    Threshold Factor          380000    
    Threshold            380000    
    2017-12-15 16:04    Server
    Medium Gateway (internal)       Value    
    ---------------------------------------- ----------    
    Configured Units            4    
    Available Units            4    
    Acquires              0    
    Waiters               0    
    Threshold Factor           12    
    Threshold              -1    
    2017-12-15 16:04    Server
    Big Gateway (internal)        Value    
    ---------------------------------------- ----------    
    Configured Units            1    
    Available Units            1    
    Acquires              0    
    Waiters               0    
    Threshold Factor            8    
    Threshold              -1    
    2017-12-15 16:04    Server
    Optimization Queue (default)      Value    
    ---------------------------------------- ----------    
    Overall Memory          124682240    
    Target Memory           3891200    
    Last Notification           0    
    Timeout               6    
    Early Termination Factor         5    
    2017-12-15 16:04    Server
    Small Gateway (default)        Value    
    ---------------------------------------- ----------    
    Configured Units           16    
    Available Units            16    
    Acquires              0    
    Waiters               0    
    Threshold Factor          380000    
    Threshold            380000    
    2017-12-15 16:04    Server
    Medium Gateway (default)        Value    
    ---------------------------------------- ----------    
    Configured Units            4    
    Available Units            4    
    Acquires              0    
    Waiters               0    
    Threshold Factor           12    
    Threshold              -1    
    2017-12-15 16:04    Server
    Big Gateway (default)         Value    
    ---------------------------------------- ----------    
    Configured Units            1    
    Available Units            1    
    Acquires              0    
    Waiters               0    
    Threshold Factor            8    
    Threshold              -1    
    2017-12-15 16:04    Server
    Memory Pool Manager          KB    
    ---------------------------------------- ----------    
    Reserved Current            0    
    Reserved Limit           310464    
    2017-12-15 16:04    Server
    Memory Pool (internal)         KB    
    ---------------------------------------- ----------    
    Allocations            149536    
    Predicted            149536    
    Private Target            0    
    Private Limit             0    
    Total Target           144312    
    Total Limit            461776    
    OOM Count              0    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_CACHE (internal)      KB    
    ---------------------------------------- ----------    
    Allocations            8728    
    Rate                0    
    Target Allocations          5904    
    Future Allocations           0    
    Overall             121760    
    Last Notification           2    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_STEAL (internal)      KB    
    ---------------------------------------- ----------    
    Allocations            62416    
    Rate               -56    
    Target Allocations          42256    
    Future Allocations           0    
    Overall             121760    
    Last Notification           2    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_RESERVE (internal)     KB    
    ---------------------------------------- ----------    
    Allocations             0    
    Rate                0    
    Target Allocations          3800    
    Future Allocations           0    
    Overall             121760    
    Last Notification           0    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_COMMITTED (internal)    KB    
    ---------------------------------------- ----------    
    Allocations            73944    
    Rate                0    
    Target Allocations          50056    
    Future Allocations           0    
    Overall             121760    
    Last Notification           2    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal)   KB    
    ---------------------------------------- ----------    
    Allocations             0    
    Rate                0    
    Target Allocations          3800    
    Future Allocations           0    
    Overall             121760    
    Last Notification           0    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_XTP (internal)      KB    
    ---------------------------------------- ----------    
    Allocations            4448    
    Rate                0    
    Target Allocations          3800    
    Future Allocations           0    
    Overall             121760    
    Last Notification           2    
    2017-12-15 16:04    Server
    Memory Pool (default)          KB    
    ---------------------------------------- ----------    
    Allocations            1776    
    Predicted             30304    
    Private Target            0    
    Private Limit             0    
    Total Target           144312    
    Total Limit            461776    
    OOM Count              0    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_CACHE (default)      KB    
    ---------------------------------------- ----------    
    Allocations            1288    
    Rate                0    
    Target Allocations          3800    
    Future Allocations           0    
    Overall             121760    
    Last Notification           0    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_STEAL (default)      KB    
    ---------------------------------------- ----------    
    Allocations             488    
    Rate                0    
    Target Allocations          3800    
    Future Allocations           0    
    Overall             121760    
    Last Notification           0    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_RESERVE (default)     KB    
    ---------------------------------------- ----------    
    Allocations             0    
    Rate                0    
    Target Allocations          3800    
    Future Allocations          28528    
    Overall             121760    
    Last Notification           0    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_HASHED_DATA_PAGES (default)   KB    
    ---------------------------------------- ----------    
    Allocations             0    
    Rate                0    
    Target Allocations          3800    
    Future Allocations           0    
    Overall             121760    
    Last Notification           0    
    2017-12-15 16:04    Server
    MEMORYBROKER_FOR_XTP (default)       KB    
    ---------------------------------------- ----------    
    Allocations             0    
    Rate                0    
    Target Allocations          3800    
    Future Allocations           0    
    Overall             121760    
    Last Notification           0    
    2017-12-15 16:04    Server
    2017-12-15 16:04    Server
    2017-12-15 16:04    Server
    2017-12-15 16:04    Server
    2017-12-15 16:04    Server
    2017-12-15 16:04    Server
    2017-12-15 16:04    Server
    2017-12-15 16:04    Server
    2017-12-15 16:04    Server
    2017-12-15 16:04    spid56
    2017-12-15 16:04    spid56
    2017-12-15 16:04    spid54
    2017-12-15 16:04    spid54
    2017-12-15 16:04    spid53
    2017-12-15 16:04    spid53
    2017-12-15 16:04    spid38s
    2017-12-15 16:04    spid38s
    2017-12-15 16:04    spid21s
    2017-12-15 16:04    spid21s
    2017-12-15 16:04    spid19s
    2017-12-15 16:04    spid19s
    2017-12-15 16:04    spid54
    2017-12-15 16:04    spid54
    2017-12-15 16:04    spid53
    2017-12-15 16:04    spid53
    2017-12-15 16:04    spid56
    2017-12-15 16:04    spid56
    2017-12-15 17:00    spid29s
    2017-12-15 17:00    spid29s
    Process/System Counts         Value    
    ---------------------------------------- ----------    
    Available Physical Memory      243150848    
    Available Virtual Memory      140712946774016    
    Available Paging File        42139648    
    Working Set           200814592    
    Percent of Committed Memory in WS     100    
    Page Faults            461045    
    System physical memory high        0    
    System physical memory low        1    
    Process physical memory low        1    
    Process virtual memory low        0    
    2017-12-15 17:00    spid29s
    Memory Manager            KB    
    ---------------------------------------- ----------    
    VM Reserved           23559516    
    VM Committed           148528    
    Locked Pages Allocated          0    
    Large Pages Allocated          0    
    Emergency Memory           1024    
    Emergency Memory In Use         16    
    Target Committed          148528    
    Current Committed          148528    
    Pages Allocated           74584    
    Pages Reserved            0    
    Pages Free              0    
    Pages In Use           148496    
    Page Alloc Potential         -7392    
    NUMA Growth Phase           2    
    Last OOM Factor            1    
    Last OS Error             0    
    2017-12-15 17:00    spid29s
    Memory node Id = 0           KB    
    ---------------------------------------- ----------    
    VM Reserved           23559452    
    VM Committed           148488    
    Locked Pages Allocated          0    
    Pages Allocated           74584    
    Pages Free              0    
    Target Committed          148480    
    Current Committed          148488    
    Foreign Committed           0    
    Away Committed            0    
    Taken Away Committed          0    
    2017-12-15 17:00    spid29s
    Memory node Id = 1           KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             20    
    Locked Pages Allocated          0    
    Pages Allocated            0    
    Pages Free              0    
    Target Committed           24    
    Current Committed           24    
    Foreign Committed           0    
    Away Committed            0    
    Taken Away Committed          0    
    2017-12-15 17:00    spid29s
    Memory node Id = 64          KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             20    
    Locked Pages Allocated          0    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLGENERAL (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           6544    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLBUFFERPOOL (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved           13014908    
    VM Committed            33736    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           488    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLQUERYEXEC (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            56    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLOPTIMIZER (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           1008    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_QUERYDISKSTORE (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           256    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLUTILITIES (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            80    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLSTORENG (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             512    
    VM Committed            512    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           6224    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLCONNECTIONPOOL (node 0)    KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           1128    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLCLR (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved           6300288    
    VM Committed            6700    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           11232    
    2017-12-15 17:00    Server
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLSERVICEBROKER (node 0)    KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           456    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLHTTP (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SNI (node 0)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            24    
    2017-12-15 17:00    Server
    2017-12-15 17:00    Server
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SNI (node 64)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SNI (Total)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            40    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_FULLTEXT (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           296    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLXP (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_BHF (node 0)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            48    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_XE_BUFFER (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved            8832    
    VM Committed            8832    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            0    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_XTP (node 0)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           4448    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_HOST (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SOSNODE (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           27120    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SOSNODE (node 64)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           2432    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SOSNODE (Total)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           29552    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SOSOS (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           192    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SOSMEMMANAGER (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved            5696    
    VM Committed            5576    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            0    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_FULLTEXT_SHMEM (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             96    
    SM Committed             96    
    Pages Allocated            0    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0)   KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           200    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_FSAGENT (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_FILETABLE (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_XE (node 0)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           2224    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SPATIAL (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_SQLLOGPOOL (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           2144    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_LWC (node 0)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            32    
    2017-12-15 17:00    spid29s
    MEMORYCLERK_FSCHUNKER (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            48    
    2017-12-15 17:00    spid29s
    CACHESTORE_OBJCP (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_SQLCP (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           1640    
    2017-12-15 17:00    spid29s
    CACHESTORE_PHDR (node 0)         KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_XPROC (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    CACHESTORE_TEMPTABLES (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    CACHESTORE_NOTIF (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    CACHESTORE_VIEWDEFINITIONS (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    CACHESTORE_XMLDBTYPE (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_XMLDBELEMENT (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_XMLDBATTRIBUTE (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_STACKFRAMES (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_STACKFRAMES (node 64)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_STACKFRAMES (Total)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    CACHESTORE_BROKERTBLACS (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            56    
    2017-12-15 17:00    spid29s
    CACHESTORE_BROKERKEK (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_BROKERDSH (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_BROKERUSERCERTLOOKUP (node 0)   KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_BROKERRSB (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_BROKERREADONLY (node 0)     KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            32    
    2017-12-15 17:00    spid29s
    CACHESTORE_BROKERTO (node 0)       KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            8    
    2017-12-15 17:00    spid29s
    CACHESTORE_EVENTS (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            16    
    2017-12-15 17:00    spid29s
    CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0)   KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated            80    
    2017-12-15 17:00    spid29s
    CACHESTORE_SYSTEMROWSET (node 0)      KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0    
    Pages Allocated           224    
    2017-12-15 17:00    spid29s
    CACHESTORE_CONVPRI (node 0)        KB    
    ---------------------------------------- ----------    
    VM Reserved             0    
    VM Committed             0    
    Locked Pages Allocated          0    
    SM Reserved             0    
    SM Committed             0