none
如何分析dbcc memorystatus 在 SQL Sever 2008 RRS feed

  • 问题

  • 我的SQL Server 2008 存在内存瓶颈:

     

    我用dbcc memorystatus 得到的报告是:

    Memory Manager                           KB

    ---------------------------------------- -----------

    VM Reserved                              23617160

    VM Committed                             14818444

    Locked Pages Allocated                   0

    Reserved Memory                          1024

    Reserved Memory In Use                   0

     

     

    Memory node Id = 0                        KB

    ---------------------------------------- -----------

    VM Reserved                              23613512

    VM Committed                             14814908

    Locked Pages Allocated                   0

    MultiPage Allocator                       387400

    SinglePage Allocator                     3265000

     

     

    MEMORYCLERK_SQLBUFFERPOOL (node 0)       KB

    ---------------------------------------- -----------

    VM Reserved                              16809984

    VM Committed                             14184208

    Locked Pages Allocated                   0

    SM Reserved                              0

    SM Committed                             0

    SinglePage Allocator                     0

    MultiPage Allocator                      408

     

    MEMORYCLERK_SQLCLR (node 0)               KB

    ---------------------------------------- -----------

    VM Reserved                              6311612

    VM Committed                             141616

    Locked Pages Allocated                   0

    SM Reserved                              0

    SM Committed                              0

    SinglePage Allocator                     1456

    MultiPage Allocator                      20144

     

    CACHESTORE_SQLCP (node 0)                KB

    ---------------------------------------- -----------

    VM Reserved                               0

    VM Committed                             0

    Locked Pages Allocated                   0

    SM Reserved                              0

    SM Committed                             0

    SinglePage Allocator                     3101784

    MultiPage Allocator                       300328

     

    Buffer Pool                              Value

    ---------------------------------------- -----------

    Committed                                1742946

    Target                                   1742946

    Database                                  1333883

    Dirty                                    940

    In IO                                    1

    Latched                                  18

    Free                                     89

    Stolen                                   408974

    Reserved                                  2080

    Visible                                  1742946

    Stolen Potential                         1579938

    Limiting Factor                          13

    Last OOM Factor                          0

    Page Life Expectancy                     5463

     

    Process/System Counts                    Value

    ---------------------------------------- --------------------

    Available Physical Memory                258572288

    Available Virtual Memory                 8771398631424

    Available Paging File                     16030617600

    Working Set                              15225597952

    Percent of Committed Memory in WS        100

    Page Faults                              305556823

    System physical memory high              1

    System physical memory low               0

    Process physical memory low              0

    Process virtual memory low               0

     

    Procedure Cache                          Value

    ---------------------------------------- -----------

    TotalProcs                               11382

    TotalPages                                430160

    InUsePages                               28

     

    我不知道主要的原因是什么 ? 是cached 太多执行计划吗? 还是执行时太费内存? 请您帮我分析下或哪里有比较好的文章在分析这个

    谢谢

    2010年5月11日 13:01

答案

全部回复