none
Error: 701 - There is insufficient system memory in resource pool 'default' to run this query. RRS feed

  • Question

  •  

    Hi experts,

      We got several SQL Errors: 701 today and I found one document mentioning this ( http://blogs.msdn.com/b/poojakamath/archive/2014/12/24/there-is-insufficient-system-memory-in-resource-pool-internal-to-run-this-query-error-701-severity-17-state-123-quot-on-ssb-target-server-cachestore-brokerto-is-consuming-memory.aspx )

    but it seems my Server Broker is ok. Anyway, how to analyze the result of DBCC MEMORYSTATUS and identify which processes/components consume too much memory?

    The SQL server version is Microsoft SQL Server 2012 (SP2-CU7) (KB3072100) - 11.0.5623.0 (X64) 
     Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

    and runnning on HP DL980, 64 cores, 1TB DRAM.

    --- errorlog ---

    2016-02-16 04:26:39.26 spid2121    Error: 14421, Severity: 16, State: 1.
    2016-02-16 04:26:39.26 spid2121    The log shipping secondary database DL980-3.TCP has restore threshold of 45 minutes and is out of sync. No restore was performed for 408579 minutes. Restored latency is 17 minutes. Check agent log and logshipping monitor information.
    2016-02-16 04:27:59.42 spid2284     Failed allocate pages: FAIL_PAGE_ALLOCATION 207
    2016-02-16 04:28:00.10 spid2284   
    Process/System Counts                         Value
    ---------------------------------------- ----------
    Available Physical Memory                23512313856
    Available Virtual Memory                 74109546496
    Available Paging File                    337114435584
    Working Set                              44043255808
    Percent of Committed Memory in WS               100
    Page Faults                                26218401
    System physical memory high                       0
    System physical memory low                        0
    Process physical memory low                       0
    Process virtual memory low                        0
    2016-02-16 04:28:00.10 spid2284   
    Memory Manager                                   KB
    ---------------------------------------- ----------
    VM Reserved                              8515836296
    VM Committed                               32772696
    Locked Pages Allocated                    950265632
    Large Pages Allocated                       6604800
    Emergency Memory                               1024
    Emergency Memory In Use                        1024
    Target Committed                          983040024
    Current Committed                         983038328
    Pages Allocated                           883841392
    Pages Reserved                                14696
    Pages Free                                  4449992
    Pages In Use                              142901680
    Page Alloc Potential                      790986320
    NUMA Growth Phase                                 2
    Last OOM Factor                                   3
    Last OS Error                                     0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 0                               KB
    ---------------------------------------- ----------
    VM Reserved                              8515446968
    VM Committed                               32537016
    Locked Pages Allocated                     90342984
    Pages Allocated                            66683032
    Pages Free                                   131632
    Target Committed                          122880000
    Current Committed                         122880000
    Foreign Committed                            359536
    Away Committed                                    0
    Taken Away Committed                              0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 1                               KB
    ---------------------------------------- ----------
    VM Reserved                                   35840
    VM Committed                                  35860
    Locked Pages Allocated                    122844136
    Pages Allocated                           116877064
    Pages Free                                   618016
    Target Committed                          122880000
    Current Committed                         122880000
    Foreign Committed                           1600924
    Away Committed                                    0
    Taken Away Committed                              0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 2                               KB
    ---------------------------------------- ----------
    VM Reserved                                  189456
    VM Committed                                  35860
    Locked Pages Allocated                    122842716
    Pages Allocated                           116615568
    Pages Free                                   757064
    Target Committed                          122880000
    Current Committed                         122878576
    Foreign Committed                            715576
    Away Committed                                    0
    Taken Away Committed                              0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 3                               KB
    ---------------------------------------- ----------
    VM Reserved                                   32768
    VM Committed                                  32788
    Locked Pages Allocated                    122847208
    Pages Allocated                           117247616
    Pages Free                                   578216
    Target Committed                          122880000
    Current Committed                         122880000
    Foreign Committed                           1373532
    Away Committed                                    0
    Taken Away Committed                              0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 4                               KB
    ---------------------------------------- ----------
    VM Reserved                                   32768
    VM Committed                                  32788
    Locked Pages Allocated                    122847212
    Pages Allocated                           117208608
    Pages Free                                   556024
    Target Committed                          122880000
    Current Committed                         122880000
    Foreign Committed                            745884
    Away Committed                                    0
    Taken Away Committed                              0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 5                               KB
    ---------------------------------------- ----------
    VM Reserved                                   32768
    VM Committed                                  32788
    Locked Pages Allocated                    122847212
    Pages Allocated                           116304184
    Pages Free                                  1117072
    Target Committed                          122880000
    Current Committed                         122880000
    Foreign Committed                           5846644
    Away Committed                                    0
    Taken Away Committed                              0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 6                               KB
    ---------------------------------------- ----------
    VM Reserved                                   32768
    VM Committed                                  32788
    Locked Pages Allocated                    122846956
    Pages Allocated                           116393200
    Pages Free                                   304096
    Target Committed                          122880000
    Current Committed                         122879744
    Foreign Committed                           4729832
    Away Committed                                    0
    Taken Away Committed                              0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 7                               KB
    ---------------------------------------- ----------
    VM Reserved                                   32768
    VM Committed                                  32788
    Locked Pages Allocated                    122847208
    Pages Allocated                           116511992
    Pages Free                                   387880
    Target Committed                          122880000
    Current Committed                         122880000
    Foreign Committed                           1912704
    Away Committed                                    0
    Taken Away Committed                              0
    2016-02-16 04:28:00.10 spid2284   
    Memory node Id = 64                              KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                     20
    Locked Pages Allocated                            0
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLGENERAL (node 0)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                              139792
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLGENERAL (node 1)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  24
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLGENERAL (node 3)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLGENERAL (node 4)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 216
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLGENERAL (node 6)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 216
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLGENERAL (node 7)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 144
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLGENERAL (Total)                   KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                              140408
    2016-02-16 04:28:00.10 spid2284   


    2016-02-16 04:28:17.39 spid2284    Error: 701, Severity: 17, State: 123.
    2016-02-16 04:28:17.39 spid2284    There is insufficient system memory in resource pool 'default' to run this query. Please check complete DBCC MEMORY STATUS below.


    Tuesday, February 16, 2016 5:32 AM

Answers

  • Hi Shanky,

      I google and find this bug. ( https://support.microsoft.com/en-gb/kb/3074434 )

    I prepare to install SP3. Any thoughts?

    ---

    Aaron Morelli on Twitter: "New Trace Flag: 8075 fixes VAS ...

    <cite class="_Rm" style="font-style:normal;color:#006621;font-size:14px;">https://twitter.com/sqlcrossjoin/status/623525334441312256</cite>

    Jul 21, 2015 - @sqlcrossjoin ... @sqlcrossjoin .... New Trace Flag: 8075 fixes VAS exhaustion (on x64!) problem after applying SQL 2012 SP2 CU7.

    ---

    If you see continuous growth in virtual address space even after you apply the fix, you can determine which queries or operations are requesting large chunks of memory by using the Page_allocated extended event. A sample script looks like this: 

    CREATE EVENT SESSION [memory_tracking] ON SERVER
    ADD EVENT sqlos.page_allocated(
        ACTION(package0.callstack,sqlos.cpu_id,sqlos.task_address,sqlos.worker_address,sqlserver.database_id,sqlserver.query_hash,sqlserver.request_id,sqlserver.session_id,sqlserver.sql_text)
        WHERE ([number_pages]>(1)))
    ADD TARGET package0.event_file(SET filename=N'E:\Data\MSSQL11.MSSQLSERVER\MSSQL\Log\memory_tracking.xel')
    WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=PER_CPU,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
    GO



    • Edited by dennislee124 Tuesday, February 23, 2016 7:32 AM
    • Marked as answer by dennislee124 Wednesday, March 2, 2016 7:18 AM
    Tuesday, February 23, 2016 7:13 AM
  • Dennis,

    Creating event trace to find out queries taking lot of VAS is good idea but I am not sure about enabling trace flag, If I were you I would apply SP3 to be on safer side.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    • Marked as answer by dennislee124 Wednesday, March 2, 2016 7:18 AM
    Wednesday, February 24, 2016 5:20 AM
    Moderator

All replies

  • PART II

    MEMORYCLERK_SQLBUFFERPOOL (node 0)               KB
    ---------------------------------------- ----------
    VM Reserved                               209014836
    VM Committed                                2097152
    Locked Pages Allocated                     44297344
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                           818485816
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLBUFFERPOOL (node 1)               KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                             2458944
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLBUFFERPOOL (node 2)               KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                             2458824
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLBUFFERPOOL (node 3)               KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                             2458256
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLBUFFERPOOL (node 4)               KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                             2458544
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLBUFFERPOOL (node 5)               KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                             2459584
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLBUFFERPOOL (node 6)               KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                             2458904
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLBUFFERPOOL (node 7)               KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                             2473256
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLBUFFERPOOL (Total)                KB
    ---------------------------------------- ----------
    VM Reserved                               209014836
    VM Committed                                2097152
    Locked Pages Allocated                     44297344
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                           835712128
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLQUERYEXEC (node 0)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               64280
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLQUERYEXEC (node 1)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                   8
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLQUERYEXEC (node 3)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  48
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLQUERYEXEC (node 6)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  48
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLQUERYEXEC (Total)                 KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               64384
    2016-02-16 04:28:00.10 spid2284  

    Tuesday, February 16, 2016 5:35 AM
  • PART III

    MEMORYCLERK_SQLOPTIMIZER (node 0)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               15152
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLOPTIMIZER (node 1)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 304
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLOPTIMIZER (node 3)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  64
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLOPTIMIZER (node 6)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 728
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLOPTIMIZER (node 7)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 624
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLOPTIMIZER (Total)                 KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               16872
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLUTILITIES (node 0)                KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 224
    2016-02-16 04:28:00.10 spid2284   
    MEMORYCLERK_SQLSTORENG (node 0)                  KB
    ---------------------------------------- ----------
    VM Reserved                                   14528
    VM Committed                                      0
    Locked Pages Allocated                        14528
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                              151672
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSTORENG (node 1)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                6144
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSTORENG (node 2)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSTORENG (node 4)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               24632
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSTORENG (node 5)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3776
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSTORENG (node 6)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 736
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSTORENG (node 7)                  KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               45736
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSTORENG (Total)                   KB
    ---------------------------------------- ----------
    VM Reserved                                   14528
    VM Committed                                      0
    Locked Pages Allocated                        14528
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                              232712
    2016-02-16 04:28:00.11 spid2284   

    Tuesday, February 16, 2016 5:38 AM
  • PART IV

    MEMORYCLERK_SQLCONNECTIONPOOL (node 0)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               12072
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 1)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11920
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 2)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               12560
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 3)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11232
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 4)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11552
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 5)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11296
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 6)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11568
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 7)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11552
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (Total)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               93752
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCLR (node 0)                      KB
    ---------------------------------------- ----------
    VM Reserved                                25196864
    VM Committed                                  26536
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                              159680
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 432
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (node 1)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (Total)             KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 448
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLHTTP (node 1)                     KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                   8
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 0)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 824
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 1)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 2)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 856
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 3)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 4)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 5)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 808
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 6)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 7)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 816
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 64)                        KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (Total)                          KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                6680
    2016-02-16 04:28:00.11 spid2284  

    Tuesday, February 16, 2016 5:41 AM
  • PART IV

    MEMORYCLERK_SQLCONNECTIONPOOL (node 0)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               12072
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 1)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11920
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 2)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               12560
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 3)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11232
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 4)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11552
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 5)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11296
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 6)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11568
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 7)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11552
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (Total)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               93752
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCLR (node 0)                      KB
    ---------------------------------------- ----------
    VM Reserved                                25196864
    VM Committed                                  26536
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                              159680
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 432
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (node 1)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (Total)             KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 448
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLHTTP (node 1)                     KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                   8
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 0)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 824
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 1)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 2)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 856
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 3)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 4)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 5)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 808
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 6)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 7)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 816
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 64)                        KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (Total)                          KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                6680
    2016-02-16 04:28:00.11 spid2284  

    Tuesday, February 16, 2016 5:48 AM
  • PART IV

    MEMORYCLERK_SQLCONNECTIONPOOL (node 0)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               12072
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 1)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11920
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 2)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               12560
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 3)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11232
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 4)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11552
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 5)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11296
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 6)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11568
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (node 7)           KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               11552
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLCONNECTIONPOOL (Total)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                               93752
    2016-02-16 04:28:00.11 spid2284   

    Tuesday, February 16, 2016 5:53 AM
  • PART V

    MEMORYCLERK_SQLCLR (node 0)                      KB
    ---------------------------------------- ----------
    VM Reserved                                25196864
    VM Committed                                  26536
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                              159680
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 432
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (node 1)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (Total)             KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 448
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLHTTP (node 1)                     KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                   8
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 0)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 824
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 1)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 2)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 856
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 3)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 4)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 5)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 808
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 6)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 7)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 816
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 64)                        KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (Total)                          KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                6680
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_FULLTEXT (node 6)                    KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 296
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLXP (node 0)                       KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 0)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3552
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 1)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3696
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 2)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3472
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 3)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3408
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 4)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3456
    2016-02-16 04:28:00.11 spid2284   

    Tuesday, February 16, 2016 5:56 AM
  • PART V

    MEMORYCLERK_SQLCLR (node 0)                      KB
    ---------------------------------------- ----------
    VM Reserved                                25196864
    VM Committed                                  26536
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                              159680
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 432
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (node 1)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLSERVICEBROKER (Total)             KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 448
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLHTTP (node 1)                     KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                   8
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 0)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 824
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 1)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 2)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 856
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 3)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 4)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 5)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 808
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 6)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 840
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 7)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 816
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (node 64)                        KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SNI (Total)                          KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                6680
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_FULLTEXT (node 6)                    KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                 296
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_SQLXP (node 0)                       KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                  16
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 0)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3552
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 1)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3696
    2016-02-16 04:28:00.11 spid2284   

    Tuesday, February 16, 2016 6:00 AM
  • PART VI

    MEMORYCLERK_BHF (node 2)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3472
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 3)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3408
    2016-02-16 04:28:00.11 spid2284   
    MEMORYCLERK_BHF (node 4)                         KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                                3456
    2016-02-16 04:28:00.11 spid2284   

    Tuesday, February 16, 2016 6:02 AM
  • --- sp_configure ---

    access check cache bucket count 0 65536 0 0
    access check cache quota 0 2147483647 0 0
    Ad Hoc Distributed Queries 0 1 0 0
    affinity I/O mask -2147483648 2147483647 0 0
    affinity mask -2147483648 2147483647 0 0
    affinity64 I/O mask -2147483648 2147483647 0 0
    affinity64 mask -2147483648 2147483647 0 0
    Agent XPs 0 1 1 1
    allow updates 0 1 0 0
    backup compression default 0 1 1 1
    blocked process threshold (s) 0 86400 0 0
    c2 audit mode 0 1 0 0
    clr enabled 0 1 0 0
    common criteria compliance enabled 0 1 0 0
    contained database authentication 0 1 0 0
    cost threshold for parallelism 0 32767 5 5
    cross db ownership chaining 0 1 0 0
    cursor threshold -1 2147483647 -1 -1
    Database Mail XPs 0 1 1 1
    default full-text language 0 2147483647 1033 1033
    default language 0 9999 0 0
    default trace enabled 0 1 1 1
    disallow results from triggers 0 1 0 0
    EKM provider enabled 0 1 0 0
    filestream access level 0 2 0 0
    fill factor (%) 0 100 0 0
    ft crawl bandwidth (max) 0 32767 100 100
    ft crawl bandwidth (min) 0 32767 0 0
    ft notify bandwidth (max) 0 32767 100 100
    ft notify bandwidth (min) 0 32767 0 0
    in-doubt xact resolution 0 2 0 0
    index create memory (KB) 704 2147483647 0 0
    lightweight pooling 0 1 0 0
    locks 5000 2147483647 0 0
    max degree of parallelism 0 32767 1 1
    max full-text crawl range 0 256 4 4
    max server memory (MB) 128 2147483647 960000 960000
    max text repl size (B) -1 2147483647 65536 65536
    max worker threads 128 65535 0 0
    media retention 0 365 0 0
    min memory per query (KB) 512 2147483647 1024 1024
    min server memory (MB) 0 2147483647 960000 960000
    nested triggers 0 1 1 1
    network packet size (B) 512 32767 4096 4096
    Ole Automation Procedures 0 1 0 0
    open objects 0 2147483647 0 0
    optimize for ad hoc workloads 0 1 0 0
    PH timeout (s) 1 3600 60 60
    precompute rank 0 1 0 0
    priority boost 0 1 0 0
    query governor cost limit 0 2147483647 0 0
    query wait (s) -1 2147483647 -1 -1
    recovery interval (min) 0 32767 0 0
    remote access 0 1 1 1
    remote admin connections 0 1 1 1
    remote login timeout (s) 0 2147483647 10 10
    remote proc trans 0 1 0 0
    remote query timeout (s) 0 2147483647 600 600
    Replication XPs 0 1 0 0
    scan for startup procs 0 1 0 0
    server trigger recursion 0 1 1 1
    set working set size 0 1 0 0
    show advanced options 0 1 1 1
    SMO and DMO XPs 0 1 1 1
    transform noise words 0 1 0 0
    two digit year cutoff 1753 9999 2049 2049
    user connections 0 32767 0 0
    user options 0 32767 0 0
    xp_cmdshell 0 1 1 1
    Tuesday, February 16, 2016 6:33 AM
  • --- dbcc memorystatus ---

    Available Physical Memory 23123087360
    Available Virtual Memory 73900920832
    Available Paging File 3.36447E+11
    Working Set 44061253632
    Percent of Committed Memory in WS 100
    Page Faults 26599943
    System physical memory high 0
    System physical memory low 0
    Process physical memory low 0
    Process virtual memory low 0
    VM Reserved 8515837256
    VM Committed 32772696
    Locked Pages Allocated 950267312
    Large Pages Allocated 6604800
    Emergency Memory 1024
    Emergency Memory In Use 800
    Target Committed 983040008
    Current Committed 983040008
    Pages Allocated 817268944
    Pages Reserved 401216
    Pages Free 70906520
    Pages In Use 143548352
    Page Alloc Potential 790339648
    NUMA Growth Phase 2
    Last OOM Factor 3
    Last OS Error 0
    Tuesday, February 16, 2016 6:36 AM
  • Hi Dennislee,

    Thank you for posting detailed information but actually DBCC memorystatus has lot of things undocumented and I cannot actually reach to conclusion reading it. I would request you to post output of below queries. Please post them neatly and follow the formatting so that it is easy to read.

    Few questions

    When are you getting this error ? Are you running specific query and getting this error. Can you also upload output of sp_readerrorlog on shared drive like dropbox or google drive so that I can hve a look. This would help me in providing better answer. Please dont post errorlog here it would unnecessarily make thread big.

    select @@Version
    go
    select physical_memory_in_use_kb/1024 as Phys_mem_mb,
    large_page_allocations_kb/1024 as Large_pages_mb,
    locked_page_allocations_kb/1024 LPIM_MB,
    virtual_address_space_committed_kb/1024 Total_memory_utilized_MB
     from sys.dm_os_process_memory
    go
    select physical_memory_kb/1024 as Phy_mem_MB,
    committed_kb/1024 as committed_mb,
    stack_size_in_bytes/1024 SS_MB,
    max_workers_count,sqlserver_start_time,virtual_machine_type_desc from sys.dm_os_sys_info
    go
    select top 10 type,
    sum(pages_kb)/1024 as [Memory utilized in MB],
    sum(awe_allocated_kb)/1024 as [Memory allocated though Windows API]
     from sys.dm_os_memory_clerks
     group by type
     order by [Memory utilized in MB] desc
     Go
    -------
    
     select (virtual_address_space_committed_kb/1024) as virtual_address_space_committed_MB,
     (locked_page_allocations_kb/1024) locked_page_allocations_MB,
     (pages_kb/1024) [memory allocated MB]
      from sys.dm_os_memory_nodes
      where memory_node_id <> 64
      Go
    -------
    SELECT top 10 SUM (pages_in_bytes)/1024 as 'KB Used', type 
    FROM sys.dm_os_memory_objects
    GROUP BY type 
    ORDER BY 'KB Used' DESC;
    GO
    --------
    select top 10 name,
    type,
    sum(pages_kb)/1024 as [Mem MB],
    sum(entries_count) as [Total Entry count] from sys.dm_os_memory_cache_counters
    group by
    type, name
    order by [Mem MB] desc
    Go
    -----
    select * from sys.dm_os_loaded_modules where company <> 'Microsoft Corporation'
    go


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP


    Tuesday, February 16, 2016 7:33 AM
    Moderator
  • Hi Shanky,

      Thanks for your reply. Actually, one Microsoft PFE told me use this T-SQL script to take a snapshot. And use perfmon -> process -> private & virtual memory to monitor a user-mode memory leak.

    A1: I got the errors this morning.

    A2: Yes, probably. It's a SAP system and there are always many programs running.

    By the way, could you access this file in google drive? It is a .rpt file, you can use notepad to open it.( https://drive.google.com/file/d/0B2C5pdGk53Pddy1rNkZoY1h1SnM/view?usp=sharing )

    --- TSQL ---

    select
    session_id, request_time, grant_time ,
    requested_memory_kb / ( 1024.0 * 1024 ) as requested_memory_gb ,
    granted_memory_kb / ( 1024.0 * 1024 ) as granted_memory_gb ,
    used_memory_kb / ( 1024.0 * 1024 ) as used_memory_gb ,
    st.text
    from 
    sys.dm_exec_query_memory_grants g  cross apply sys.dm_exec_sql_text(sql_handle) as  st
    -- uncomment the where conditions as needed
    -- where grant_time is not null  -- these sessions are using memory allocations
    -- where grant_time is     null  -- these sessions are waiting for memory allocations



    Tuesday, February 16, 2016 9:17 AM
  • Tuesday, February 16, 2016 9:18 AM
  • I cannot access the google drive please provide every one access and then you can remove it.

    What is collective size of all databases and size of biggest database ?


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP


    Tuesday, February 16, 2016 10:11 AM
    Moderator
  • Hi Shanky,

      I ask me colleague to download and it is ok.

    Please try this. It shows "everyone with this link can view"

    https://drive.google.com/file/d/0B2C5pdGk53Pddy1rNkZoY1h1SnM/view?usp=sharing

    Thursday, February 18, 2016 2:36 AM
  • Hi Shanky,

      I ask me colleague to download and it is ok.

    Please try this. It shows "everyone with this link can view"

    https://drive.google.com/file/d/0B2C5pdGk53Pddy1rNkZoY1h1SnM/view?usp=sharing

    Ok thanks for BIG log file. After looking at logs I think you might be facing bug fixed in SQL Server 2012 Sp2 CU8. What I recommend is go ahead and install SQL Server 2012 Sp3 as this would include CU8 and SP are more reliable than CU.

    From DBCC memorystatus output I can note

    Process/System Counts                         Value
    ---------------------------------------- ----------
    Available Physical Memory                28085694464
    Available Virtual Memory                 1467298451456-Approx 1 TB

    

    Then on second memory dump

    2016-02-15 13:26:34.220 spid1067     
    Process/System Counts                         Value
    ---------------------------------------- ----------
    Available Physical Memory                23491231744
    Available Virtual Memory                 74045636608--approx 70G

    Then on 3rd memory dump

    2016-02-15 16:17:49.450 spid1245     
    Process/System Counts                         Value
    ---------------------------------------- ----------
    Available Physical Memory                23390035968
    Available Virtual Memory                 73896366080--decreased bit more to 69G

    This is as per what is indicated in the KB article.

    Also you have very high VM reserved and this is also pointed in KB article. Have a look

    2016-02-15 16:17:49.450 spid1245     
    Memory Manager                                   KB
    ---------------------------------------- ----------
    VM Reserved                              8515832712-
    VM Committed                               32772696

    Reserved is very high and committed is very less. Reserved 7.8 TB committed is just 3 G.

    You are also using extended stored procs which can also cause memory pressure

    2015-12-04 14:48:24.980 spid51       Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required. spid51       Using 'xpsqlbot.dll' version '2011.110.2100' to execute extended stored 

    Now lest have a look at SQL Server memory consumption.

    SQL Server is using physical memory of 953.5 G

    The total memory(RAM+Pagefile) it is using is 1867.5 G. Which means paging file or amount of memory paged would be difference of above 2 and that would be 914 G. This is too much why SQL server is paging so much memory.

    And it seems you have configured log shipping on AlwaysON Availability groups and you have your logs filled with message

    Error: 14421, Severity: 16, State: 1.
    2016-02-15 16:14:00.450 spid358      The log shipping secondary database DL980-3.QAP has restore threshold of 45 minutes and is out of sync. No restore was performed for 126817 minutes. Restored latency is 7 minutes. Check agent log and logshipping monitor information.

    You must also look into this.

    CAN you also show me output of below queries

    select virtual_address_space_reserved_kb/1024 as VASR_MB from sys.dm_os_process_memory
    
    select virtual_address_space_reserved_kb/1024 as VASR_MB sys.dm_os_memory_nodes 

    Does queries take longer time to execute and waits on SOS_MEMORY_TOPLEVELBLOCKALLOCATOR waits

    Do you also see CMMTHREAD wait types ?


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP


    Thursday, February 18, 2016 10:24 AM
    Moderator
  • Can you post the actual ERRORLOG file, not the sp_readerrorlog output, which is truncating some the DBCC MEMORYSTATUS information necessary to diagnose your problem.  The details of what is contained in DBCC MEMORYSTATUS is documented in the following KB article:  https://support.microsoft.com/en-us/kb/907877

    The memory brokers have nothing to do with Service Broker, they are an internal SQLOS object that is used by the SOS memory manager to track memory usage and allocations by different memory objects and clerks inside of the system.  While you posted the entire output in the thread, it's too much to have to scroll through without fixed width formatting and there are repeats of the information, so just looking at the raw ERRORLOG file would be much easier to finding where your memory is actually going.  What you ran into is pool level pressure within the default resource governor pool.  Even if you don't use resource governor explicitly, or you are on Standard/Express Edition, SQL Server uses two system resource pools for everything happening in the system, internal for system tasks and memory requirements, and default for all user connection requirements.  If we can track the clerk allocating the memory from the DBCC MEMORYSTATUS output, we can better pin down why you had default pool pressure that created the 701 error.  


    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server

    Thursday, February 18, 2016 8:07 PM
    Moderator
  • Hi Jonathan,

      I really appreciate your help. This system has 960GB memory allocated(fixed) for SQL server and I found some programs can consume up to 177GB sometimes. Because it occurred intermittently, I can't make sure if it is related to Error: 701.

      I upload errorlog.zip in here ( https://drive.google.com/file/d/0B2C5pdGk53PdOWotcUhmSXF1U3M/view?usp=sharing ). You can open it with 7zip.

      Also, the orginal errorlog file is uploaded ( https://drive.google.com/file/d/0B2C5pdGk53PdRTAzSnJEcHFaQ0U/view?usp=sharing )

    Friday, February 19, 2016 2:35 AM
  • Hi Shanky,

      Ok. If the problem persists, I will update SQL server to SP3.

    Friday, February 19, 2016 2:51 AM
  • With Jonathan looking at this thread you are sure in better hand. I would just like to add my few cents

    1. You had some serious stack dumps which were saying its is kind of assertion error how often you run DBCC checkdb ?

    Error: 17066, Severity: 16, State: 1. 2015-12-19 15:34:07.05 spid1604 SQL Server Assertion: File: <BtreeMgr.cpp>, line=231 Failed Assertion = 'status == BTREE_INSERT_ENTRY_SUCCEEDED'. This error may be timing-related. If the error persists after rerunning the statement, use

    DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

    2. Coming back to memory I still see very less Available virtual memory its around 74 G and this si why I pointed you to apply Sp3 but you can wait and see what Jonathn has to say about this.

    Available Physical Memory                23390035968
    Available Virtual Memory                 73 896 366 080
    
    
    Process/System Counts                         Value
    ---------------------------------------- ----------
    Available Physical Memory                23509860352
    Available Virtual Memory                 74070069248

    3. As he said correctly the errorlog trimmed some information and I was not able to see that

    MEMORYCLERK_SQLRESERVATIONS  is using quite a lot of memory 200G -372G(approx) which is really very high. I have not seen a system with so much SQLRESERVATION request. This clerk tracks memory allocations for queries which have lot of Sort and Hash match operations involved I am sure you must be seeing lot of semaphore waits and there would be memory grants pending.  This MIGHT be the cause of OOM error but your system seems in more bad position than this.

    I strongly suggest you to open case with Microsoft and get these Dumps analyzed.

    MEMORYCLERK_SQLQERESERVATIONS (Total)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                           200516992
    
    MEMORYCLERK_SQLQERESERVATIONS (Total)            KB
    ---------------------------------------- ----------
    VM Reserved                                       0
    VM Committed                                      0
    Locked Pages Allocated                            0
    SM Reserved                                       0
    SM Committed                                      0
    Pages Allocated                           372172528
    I also believe that the query you posted with large value of granted_memory_gb is synonymous with large value of memoryclerk_sqlreservations.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP


    Friday, February 19, 2016 5:08 AM
    Moderator
  • Hi Shanky,

      Thanks for your reply.

    A1: Due to performance concerns and extra sparse files needed on production system, I run dbcc checkdb on standby server every week.

    ---

    2016-02-17 13:07:29.09 spid263     DBCC CHECKDB (QA2) WITH physical_only executed by qa2 found 0 errors and repaired 0 errors. Elapsed time: 115 hours 8 minutes 11 seconds.  Internal database snapshot has split point LSN = 00064d99:020a9589:00b1 and first LSN = 00064d99:020a9586:0001.

    ---

    A2: Ok, maybe I will do it togather(apply Jonathan recommandation and update to SP3).

    ---

    A3: In  general, I will create a case to MS CSS in the last step. At first, sometimes Microsoft CSS recommends me to ask in MSDN before creating a case. Secondly, regional supports are not satisfied sometimes. Anyway, this is just my opinion.

    Friday, February 19, 2016 5:26 AM
  • Hi Shanky,

      I google and find this bug. ( https://support.microsoft.com/en-gb/kb/3074434 )

    I prepare to install SP3. Any thoughts?

    ---

    Aaron Morelli on Twitter: "New Trace Flag: 8075 fixes VAS ...

    <cite class="_Rm" style="font-style:normal;color:#006621;font-size:14px;">https://twitter.com/sqlcrossjoin/status/623525334441312256</cite>

    Jul 21, 2015 - @sqlcrossjoin ... @sqlcrossjoin .... New Trace Flag: 8075 fixes VAS exhaustion (on x64!) problem after applying SQL 2012 SP2 CU7.

    ---

    If you see continuous growth in virtual address space even after you apply the fix, you can determine which queries or operations are requesting large chunks of memory by using the Page_allocated extended event. A sample script looks like this: 

    CREATE EVENT SESSION [memory_tracking] ON SERVER
    ADD EVENT sqlos.page_allocated(
        ACTION(package0.callstack,sqlos.cpu_id,sqlos.task_address,sqlos.worker_address,sqlserver.database_id,sqlserver.query_hash,sqlserver.request_id,sqlserver.session_id,sqlserver.sql_text)
        WHERE ([number_pages]>(1)))
    ADD TARGET package0.event_file(SET filename=N'E:\Data\MSSQL11.MSSQLSERVER\MSSQL\Log\memory_tracking.xel')
    WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=PER_CPU,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
    GO



    • Edited by dennislee124 Tuesday, February 23, 2016 7:32 AM
    • Marked as answer by dennislee124 Wednesday, March 2, 2016 7:18 AM
    Tuesday, February 23, 2016 7:13 AM
  • Dennis,

    Creating event trace to find out queries taking lot of VAS is good idea but I am not sure about enabling trace flag, If I were you I would apply SP3 to be on safer side.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    • Marked as answer by dennislee124 Wednesday, March 2, 2016 7:18 AM
    Wednesday, February 24, 2016 5:20 AM
    Moderator
  • Hi Dennis,

    So applying SP3 solved your issue ?


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    Wednesday, March 2, 2016 7:30 AM
    Moderator