none
sql server 安装好后,启动sql server后,内存一下子占用了最大内存的量 RRS feed

  • 问题

  • 重装了一个系统,系统为windwos 2008 R2 datacenter 64位,内存为32G.数据库版本为sql server 2005 企业版 64bit ,最新补丁为sp4。数据库安装后,启动了sql server。看任务管理中已用的内存占了30多G。在数据库中设置了最大内存为28G,已用的内存下降一点。

    现在这个服务器没有做任何用途,也没有安装别的应用程序,查看进程,确实是sql server占用的内存比较多。重启sqlserver服务后,内存的占用从很小又很快升到30多G。

    DBCC MEMORYSTATUS

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

    VM Reserved 33910000
    VM Committed 338172
    AWE Allocated 29294592
    Reserved Memory 1024
    Reserved Memory In Use 0

    select type, sum(multi_pages_kb) from sys.dm_os_memory_clerks where multi_pages_kb != 0 group by type

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

    MEMORYCLERK_SQLOPTIMIZER 160
    MEMORYCLERK_SQLSTORENG 696
    OBJECTSTORE_SNI_PACKET 240
    MEMORYCLERK_SQLGENERAL 4328
    CACHESTORE_STACKFRAMES 40
    MEMORYCLERK_SQLSERVICEBROKER 304
    MEMORYCLERK_SQLBUFFERPOOL 1296
    MEMORYCLERK_SOSNODE 32944
    OBJECTSTORE_LBSS 288
    MEMORYCLERK_SNI 80

    select
        sum(awe_allocated_kb) / 1024 as [AWE allocated, Mb]
    from
        sys.dm_os_memory_clerks

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

    28632

    哪位大侠给分下,这是为什么啊


    2013年11月7日 3:01

答案

  • 首先,我并没有说“把Stolen理解为倾向于泄漏”,而是在Stolen为很大,但是看不到其他的内存组件占有这14G内存的时候才有所怀疑。

    从上面Memorystatus的结果来看,有这种可能,当然我也说了需要进一步排查,因为也有可能跟硬件配置有关,比如说NUMA。

    LZ,请把下面的语句的结果贴出来,注意的是只有在你的内存达到28G的时候,再执行Memorystatus或者是下面的语句

    select [type] ,  sum(single_pages_kb) ,sum(multi_pages_kb ),sum(awe_allocated_kb ),sum(virtual_memory_committed_kb )
    from [sys].[dm_os_memory_clerks]
    group by [type]

    Please click the Mark as Answer button if a post solves your problem!


    2013年11月9日 2:36

全部回复

  • Any other service installed on the machine? Did you double check memory usage in perfmon?
    2013年11月7日 3:27
  • 没有其他服务了, 性能计数器中,看Available MBytes :1,370.00。sql server:Memory Manager // Total Server Memory(KB) :28,840,752.00   sql server:Memory Manager // Target Server Memory(KB): 29,360,128.00 。还需要其他计数器吗? 
    2013年11月7日 3:40
  • So sql uses whatever you give to it, sounds normal.
    2013年11月7日 3:41
  • 可是为什么sql 服务一启动后,什么应用也没有,就会自动占用那么多内存呢,其他数据库服务器都是部署后随着用的越多占用才慢慢越多
    2013年11月7日 3:45
  • Did you install latest windows sp? Does sql service account have 'lock pages in memory' user rights? Did you build this server in same way as other servers?
    2013年11月7日 4:06
  • AWE Allocated 29294592

    看起来是AWE使用的部分最多了,你使用了Windows的Lock Pgaes in memory选项吗?


    Please Mark As Answer if it is helpful.


    2013年11月7日 5:48
  • 1 ,按,CTRL+T


    2,DBCC MEMORYSTATUS ()

    把结果集贴出来看看



    Please click the Mark as Answer button if a post solves your problem!

    2013年11月7日 6:02
  • 嗯,其它数据库服务器上也是这样的。但是没出现这个问题。没有锁定内存页。windows补丁打的sp1补丁

    2013年11月7日 7:10
  • Memory Manager                  KB
    ------------------------------ --------------------
    VM Reserved                    33910128
    VM Committed                   338300
    AWE Allocated                  29507584
    Reserved Memory                1024
    Reserved Memory In Use         0

    (5 行受影响)

    Memory node Id = 0              KB
    ------------------------------ --------------------
    VM Reserved                    38016
    VM Committed                   37984
    AWE Allocated                  106496
    MultiPage Allocator            5112
    SinglePage Allocator           21760

    (5 行受影响)

    Memory node Id = 1              KB
    ------------------------------ --------------------
    VM Reserved                    33788336
    VM Committed                   216848
    AWE Allocated                  106496
    MultiPage Allocator            19176
    SinglePage Allocator           21760

    (5 行受影响)

    Memory node Id = 2              KB
    ------------------------------ --------------------
    VM Reserved                    38912
    VM Committed                   38712
    AWE Allocated                  14745600
    MultiPage Allocator            5784
    SinglePage Allocator           21760

    (5 行受影响)

    Memory node Id = 3              KB
    ------------------------------ --------------------
    VM Reserved                    39104
    VM Committed                   39072
    AWE Allocated                  14548992
    MultiPage Allocator            6048
    SinglePage Allocator           21760

    (5 行受影响)

    MEMORYCLERK_SQLGENERAL (node 0)                                   KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            2896
     MultiPage Allocator                                             4328

    (7 行受影响)

    MEMORYCLERK_SQLGENERAL (node 1)                                   KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            32
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLGENERAL (node 2)                                   KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            208
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLGENERAL (node 3)                                   KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            144
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLGENERAL (Total)                                    KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            3280
     MultiPage Allocator                                             4328

    (7 行受影响)

    MEMORYCLERK_SQLBUFFERPOOL (node 0)                                KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     33603584
     VM Committed                                                    32768
     AWE Allocated                                                   106496
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             1296

    (7 行受影响)

    MEMORYCLERK_SQLBUFFERPOOL (node 1)                                KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   106496
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLBUFFERPOOL (node 2)                                KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   14745600
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLBUFFERPOOL (node 3)                                KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   14548992
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLBUFFERPOOL (Total)                                 KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     33603584
     VM Committed                                                    32768
     AWE Allocated                                                   29507584
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             1296

    (7 行受影响)

    2013年11月7日 7:17
  • 问一下你的数据库服务账户是不是有本地管理员权限?如果是的话默认是有Locak Pages In Memory的权限。

    但是我很奇怪,应该SQL Server是需要的时候才会Consume Memory,而不会一开始就先占了。你设置了MIN MEMORY没?


    Please Mark As Answer if it is helpful.



    2013年11月7日 7:21
  • 会不会有Stratup自动执行SP,查询(缓存)了数据?

    按道理说,要缓存30G内存,从磁盘上读30G,也需要几分钟呢

    一起动就占用全部内存,跟Min Memory无关


    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com

    2013年11月7日 7:39
  • 没有设,最小内存为0,最大内存设置了,28G.数据库启动账户用的是localhost
    2013年11月7日 7:47
  • 应该是没有的,在数据库中查询进程,除了系统进程,用户进程只有我用来查询的进程。现在实例中还没有建用户数据库

    2013年11月7日 7:49
  • 看一下SQL ERRORLOG有没有内存方面的报错

    问题描述:客户反映SQL Server运行一段时间就会报出内存不足的错误,怀疑是有内存泄露。
    从SQL Server的error log里面看如下错误信息:

    2009-05-14 10:54:20.71 server Error: 17803, Severity: 20, State: 17
    2009-05-14 10:54:20.71 server Insufficient memory available..

    对于这种内存错误首先我们应该检查当前SQL Server的内存配置:

    1. 32位的SQL Server还是64位的SQL Server?

    2. 如果是32位的SQL Server,有没有启用AWE的选项。

    3. 是否有设置最大服务器内存?

    2013年11月7日 8:19
  • 能否把 DBCC MEMORYSTATUS ()的结果给贴全呢,现在感觉只是贴了一部分而已。


    Please click the Mark as Answer button if a post solves your problem!

    2013年11月7日 8:45

  • MEMORYCLERK_SQLQUERYEXEC (node 0)                                 KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLQUERYEXEC (Total)                                  KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLOPTIMIZER (node 0)                                 KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            160
     MultiPage Allocator                                             160

    (7 行受影响)

    MEMORYCLERK_SQLOPTIMIZER (Total)                                  KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            160
     MultiPage Allocator                                             160

    (7 行受影响)

    MEMORYCLERK_SQLUTILITIES (node 0)                                 KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     240
     VM Committed                                                    240
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            64
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLUTILITIES (node 2)                                 KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLUTILITIES (Total)                                  KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     240
     VM Committed                                                    240
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            80
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLSTORENG (node 0)                                   KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     384
     VM Committed                                                    384
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            824
     MultiPage Allocator                                             296

    (7 行受影响)

    MEMORYCLERK_SQLSTORENG (node 2)                                   KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            136
     MultiPage Allocator                                             312

    (7 行受影响)

    MEMORYCLERK_SQLSTORENG (node 3)                                   KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            136
     MultiPage Allocator                                             88

    (7 行受影响)

    MEMORYCLERK_SQLSTORENG (Total)                                    KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     384
     VM Committed                                                    384
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            1096
     MultiPage Allocator                                             696

    (7 行受影响)

    MEMORYCLERK_SQLCONNECTIONPOOL (node 0)                            KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            80
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLCONNECTIONPOOL (node 1)                            KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            96
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLCONNECTIONPOOL (node 2)                            KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            56
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLCONNECTIONPOOL (node 3)                            KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            120
     MultiPage Allocator                                             0

    (7 行受影响)

    MEMORYCLERK_SQLCONNECTIONPOOL (Total)                             KB
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            352
     MultiPage Allocator                                             0

    这个结果太长了,怎么能上传附件哪
    2013年11月7日 10:02
  • Is localhost a windows account?
    2013年11月7日 14:18
  • 这样的场景,大伙儿猜个毛啊

    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com

    2013年11月8日 2:34
  • MEMORYCLERK_SQLCLR (node 0)                                       KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_SQLCLR (Total)                                        KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_SQLSERVICEBROKER (node 0)                             KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             304
    
    (7 行受影响)
    
    MEMORYCLERK_SQLSERVICEBROKER (Total)                              KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             304
    
    (7 行受影响)
    
    MEMORYCLERK_SQLHTTP (node 3)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_SQLHTTP (Total)                                       KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_SNI (node 0)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             16
    
    (7 行受影响)
    
    MEMORYCLERK_SNI (node 1)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             16
    
    (7 行受影响)
    
    MEMORYCLERK_SNI (node 2)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             16
    
    (7 行受影响)
    
    MEMORYCLERK_SNI (node 3)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             16
    
    (7 行受影响)
    
    MEMORYCLERK_SNI (Total)                                           KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             64
    
    (7 行受影响)
    
    MEMORYCLERK_FULLTEXT (node 3)                                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_FULLTEXT (Total)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_SQLXP (node 0)                                        KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_SQLXP (Total)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_HOST (node 2)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_HOST (Total)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_SOSNODE (node 0)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            1240
     MultiPage Allocator                                             12608
    
    (7 行受影响)
    
    MEMORYCLERK_SOSNODE (node 1)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            1072
     MultiPage Allocator                                             4792
    
    (7 行受影响)
    
    MEMORYCLERK_SOSNODE (node 2)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            1192
     MultiPage Allocator                                             5304
    
    (7 行受影响)
    
    MEMORYCLERK_SOSNODE (node 3)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            1312
     MultiPage Allocator                                             5792
    
    (7 行受影响)
    
    MEMORYCLERK_SOSNODE (Total)                                       KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            4816
     MultiPage Allocator                                             28496
    
    (7 行受影响)
    
    MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0)                    KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            48
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total)                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            48
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_OBJCP (node 0)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            4248
     MultiPage Allocator                                             0
    
    (7 行受影响)

    2013年11月8日 3:21
  • CACHESTORE_OBJCP (Total)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            4248
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_SQLCP (node 0)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            4440
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_SQLCP (Total)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            4440
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_PHDR (node 0)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            3232
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_PHDR (Total)                                           KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            3232
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_XPROC (node 0)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_XPROC (Total)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_TEMPTABLES (node 0)                                    KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_TEMPTABLES (Total)                                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_NOTIF (node 0)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_NOTIF (Total)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_VIEWDEFINITIONS (node 0)                               KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_VIEWDEFINITIONS (Total)                                KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_XMLDBTYPE (node 0)                                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_XMLDBTYPE (Total)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_XMLDBELEMENT (node 0)                                  KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_XMLDBELEMENT (Total)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_XMLDBATTRIBUTE (node 0)                                KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_XMLDBATTRIBUTE (Total)                                 KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_STACKFRAMES (node 0)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             8
    
    (7 行受影响)
    
    CACHESTORE_STACKFRAMES (node 1)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             8
    
    (7 行受影响)
    
    CACHESTORE_STACKFRAMES (node 2)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             8
    
    (7 行受影响)
    
    CACHESTORE_STACKFRAMES (node 3)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             8
    
    (7 行受影响)
    
    CACHESTORE_STACKFRAMES (Total)                                    KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            0
     MultiPage Allocator                                             32
    
    (7 行受影响)
    
    CACHESTORE_BROKERTBLACS (node 0)                                  KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            64
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERTBLACS (node 2)                                  KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            24
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERTBLACS (node 3)                                  KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            56
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERTBLACS (Total)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            144
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERKEK (node 0)                                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERKEK (Total)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERDSH (node 0)                                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERDSH (Total)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERUSERCERTLOOKUP (node 0)                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERUSERCERTLOOKUP (Total)                           KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERRSB (node 0)                                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERRSB (Total)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERREADONLY (node 0)                                KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERREADONLY (Total)                                 KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERTO (node 0)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_BROKERTO (Total)                                       KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_EVENTS (node 0)                                        KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_EVENTS (Total)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            16
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_SYSTEMROWSET (node 2)                                  KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            360
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_SYSTEMROWSET (node 3)                                  KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            488
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    CACHESTORE_SYSTEMROWSET (Total)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            848
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_SCHEMAMGR (node 0)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            416
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_SCHEMAMGR (Total)                                       KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            416
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_DBMETADATA (node 2)                                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            56
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_DBMETADATA (node 3)                                     KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            360
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_DBMETADATA (Total)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            416
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_TOKENPERM (node 0)                                      KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            280
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_TOKENPERM (Total)                                       KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            280
     MultiPage Allocator                                             0
    
    (7 行受影响)

    2013年11月8日 3:22
  • USERSTORE_OBJPERM (node 2)                                        KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            528
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_OBJPERM (node 3)                                        KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            792
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_OBJPERM (Total)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            1320
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_SXC (node 0)                                            KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_SXC (node 1)                                            KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_SXC (node 2)                                            KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_SXC (node 3)                                            KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            8
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    USERSTORE_SXC (Total)                                             KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            32
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    OBJECTSTORE_LBSS (node 0)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            48
     MultiPage Allocator                                             112
    
    (7 行受影响)
    
    OBJECTSTORE_LBSS (node 1)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            48
     MultiPage Allocator                                             64
    
    (7 行受影响)
    
    OBJECTSTORE_LBSS (node 2)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            48
     MultiPage Allocator                                             96
    
    (7 行受影响)
    
    OBJECTSTORE_LBSS (node 3)                                         KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            48
     MultiPage Allocator                                             96
    
    (7 行受影响)
    
    OBJECTSTORE_LBSS (Total)                                          KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            192
     MultiPage Allocator                                             368
    
    (7 行受影响)
    
    OBJECTSTORE_SNI_PACKET (node 0)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            120
     MultiPage Allocator                                             48
    
    (7 行受影响)
    
    OBJECTSTORE_SNI_PACKET (node 1)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            96
     MultiPage Allocator                                             48
    
    (7 行受影响)
    
    OBJECTSTORE_SNI_PACKET (node 2)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            72
     MultiPage Allocator                                             48
    
    (7 行受影响)
    
    OBJECTSTORE_SNI_PACKET (node 3)                                   KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            96
     MultiPage Allocator                                             48
    
    (7 行受影响)
    
    OBJECTSTORE_SNI_PACKET (Total)                                    KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            384
     MultiPage Allocator                                             192
    
    (7 行受影响)
    
    OBJECTSTORE_SERVICE_BROKER (node 0)                               KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            272
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    OBJECTSTORE_SERVICE_BROKER (Total)                                KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            272
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    OBJECTSTORE_LOCK_MANAGER (node 0)                                 KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     131072
     VM Committed                                                    131072
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            648
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    OBJECTSTORE_LOCK_MANAGER (node 1)                                 KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            648
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    OBJECTSTORE_LOCK_MANAGER (node 2)                                 KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            648
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    OBJECTSTORE_LOCK_MANAGER (node 3)                                 KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     0
     VM Committed                                                    0
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            648
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    OBJECTSTORE_LOCK_MANAGER (Total)                                  KB 
    ---------------------------------------------------------------- --------------------
     VM Reserved                                                     131072
     VM Committed                                                    131072
     AWE Allocated                                                   0
     SM Reserved                                                     0
     SM Commited                                                     0
     SinglePage Allocator                                            2592
     MultiPage Allocator                                             0
    
    (7 行受影响)
    
    Buffer Distribution            Buffers
    ------------------------------ -----------
    Stolen                         1793167
    Free                           1830552
    Cached                         2061
    Database (clean)               1642
    Database (dirty)               94
    I/O                            0
    Latched                        0
    
    (7 行受影响)
    
    Buffer Counts                  Buffers
    ------------------------------ --------------------
    Committed                      3627516
    Target                         3670016
    Hashed                         1736
    Stolen Potential               3483795
    External Reservation           0
    Min Free                       1024
    Visible                        3670016
    Available Paging File          4301605
    
    (8 行受影响)
    
    Procedure Cache                Value
    ------------------------------ -----------
    TotalProcs                     86
    TotalPages                     1499
    InUsePages                     0
    
    (3 行受影响)
    
     
    Global Memory Objects          Buffers
    ------------------------------ --------------------
    Resource                       213
    Locks                          327
    XDES                           72
    SETLS                          32
    SE Dataset Allocators          64
    SubpDesc Allocators            32
    SE SchemaManager               51
    SQLCache                       218
    Replication                    2
    ServerGlobal                   49
    XP Global                      2
    SortTables                     35
    
    (12 行受影响)
    
     
    Query Memory Objects           Value
    ------------------------------ -----------
    Grants                         0
    Waiting                        0
    Available (Buffers)            2745070
    Maximum (Buffers)              2745070
    Limit                          2745070
    Next Request                   0
    Waiting For                    0
    Cost                           0
    Timeout                        0
    Wait Time                      0
    Last Target                    2757870
    
    (11 行受影响)
    
    Small Query Memory Objects     Value
    ------------------------------ -----------
    Grants                         0
    Waiting                        0
    Available (Buffers)            12800
    Maximum (Buffers)              12800
    Limit                          12800
    
    (5 行受影响)
    
    Optimization Queue             Value
    ------------------------------ --------------------
    Overall Memory                 24098660352
    Target Memory                  22922731520
    Last Notification              1
    Timeout                        6
    Early Termination Factor       5
    
    (5 行受影响)
    
    Small Gateway                  Value
    ------------------------------ --------------------
    Configured Units               128
    Available Units                128
    Acquires                       0
    Waiters                        0
    Threshold Factor               380000
    Threshold                      380000
    
    (6 行受影响)
    
    Medium Gateway                 Value
    ------------------------------ --------------------
    Configured Units               32
    Available Units                32
    Acquires                       0
    Waiters                        0
    Threshold Factor               12
    
    (5 行受影响)
    
    Big Gateway                    Value
    ------------------------------ --------------------
    Configured Units               1
    Available Units                1
    Acquires                       0
    Waiters                        0
    Threshold Factor               8
    
    (5 行受影响)
    
    MEMORYBROKER_FOR_CACHE           Value
    -------------------------------- --------------------
    Allocations                      2063
    Rate                             0
    Target Allocations               2799593
    Future Allocations               0
    Last Notification                1
    
    (5 行受影响)
    
    MEMORYBROKER_FOR_STEAL           Value
    -------------------------------- --------------------
    Allocations                      654
    Rate                             1
    Target Allocations               2798185
    Future Allocations               0
    Last Notification                1
    
    (5 行受影响)
    
    MEMORYBROKER_FOR_RESERVE         Value
    -------------------------------- --------------------
    Allocations                      0
    Rate                             0
    Target Allocations               2941731
    Future Allocations               686267
    Last Notification                1
    
    (5 行受影响)
    
    DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
    这个结果太长了,没有添加附件的功能么
    2013年11月8日 3:23
  • Memory node Id = 2              KB
    ------------------------------ --------------------
    VM Reserved                    38912
    VM Committed                   38712
    AWE Allocated                  14745600
    MultiPage Allocator            5784
    SinglePage Allocator           21760

    (5 行受影响)

    Memory node Id = 3              KB
    ------------------------------ --------------------
    VM Reserved                    39104
    VM Committed                   39072
    AWE Allocated                  14548992
    MultiPage Allocator            6048
    SinglePage Allocator           21760

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

    Buffer Distribution            Buffers
    ------------------------------ -----------
    Stolen                        
    1793167
    Free                          
    1830552
    Cached                        
    2061
    Database (clean)               1642
    Database (dirty)               94
    I
    /O                            0
    Latched                       
    0

    LZ,你已经给全了是吧?

    从上面可以看出,node 2跟node 3 通过AWE分别分配了大约14G的内存,另外从Buffer Distribution 看出,Stolen了大约14G的内存,但是上面输出结果却看不出到底这14G Stolen内存给了那个内存组件,看起来似乎是SQL SERVER的内存泄漏。不过需要进一步确认。



    Please click the Mark as Answer button if a post solves your problem!

    2013年11月8日 13:30
  • 把Stolen理解为倾向于泄漏,不是个好习惯

    就这么个DBCC MEMORY结果,很片面。。就像肚子疼的原因,很可能是被人捅了一刀,不一定是感冒


    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com

    2013年11月9日 1:14
  • 首先,我并没有说“把Stolen理解为倾向于泄漏”,而是在Stolen为很大,但是看不到其他的内存组件占有这14G内存的时候才有所怀疑。

    从上面Memorystatus的结果来看,有这种可能,当然我也说了需要进一步排查,因为也有可能跟硬件配置有关,比如说NUMA。

    LZ,请把下面的语句的结果贴出来,注意的是只有在你的内存达到28G的时候,再执行Memorystatus或者是下面的语句

    select [type] ,  sum(single_pages_kb) ,sum(multi_pages_kb ),sum(awe_allocated_kb ),sum(virtual_memory_committed_kb )
    from [sys].[dm_os_memory_clerks]
    group by [type]

    Please click the Mark as Answer button if a post solves your problem!


    2013年11月9日 2:36
  • 是俺想多了,想偏了,呵呵

    低调地给Jackie Shen道个歉,以消除沟通中的代沟和误解


    Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com

    2013年11月9日 4:15
  • 严重了哥么,:-)


    Please click the Mark as Answer button if a post solves your problem!

    2013年11月10日 9:19
  • Hi Yingtaowz,

    服务器是否有4节点NUMA,并且只有一根内存条?(Node0 ~node3)

    如果是,请在BIOS里面禁用NUMA,再看内存是否仍然会开机迅速全部占用?

    2013年11月18日 8:32
  • 要是我的话我会先检查 sys.dm_os_buffer_descriptors 里边各个数据库buffer大小是否正常
    2013年11月19日 8:30