none
资源池 'default' 没有足够的系统内存来运行此查询。 RRS feed

  • 问题

  • 环境:windows2003sp2+sqlserver2008sp3

    CPU4核,8G物理内存,给SQLSERVER分配了最高使用5G,启用了AWE。

    表test_table为分区表,150万条记录。

    表test_table执行聚集索引创建时,报如下错误:

    “语句已终止。
    消息 701,级别 17,状态 123,第 1 行
    资源池 'default' 没有足够的系统内存来运行此查询。"

    CREATE CLUSTERED INDEX [IX_vdate] ON [dbo].[test_table]
    (
     [vdate] desc
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = ON, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [plan_vdate]([vdate])

    GO

    对于小的分区表操作是可以正常的,几个超过100万记录的表都会报同样的错误。

    尝试过重启SQLSERVER服务和服务器然后执行这个操作也失败。

    是不是需要调整SQLSERVER2008的什么参数才行?

    谢谢!


    • 已编辑 guaranty 2012年6月15日 11:40
    2012年6月15日 11:39

答案

  • 当然可以呀,呵呵,好几台机器都证明了。没有添加/PAE完全可以用到16G内存。
    Windows automatically enables PAE if DEP is enabled on a computer that supports hardware-enabled DEP, or if the computer is configured for hot-add memory devices in memory ranges beyond 4 GB. If the computer does not support hardware-enabled DEP or is not configured for hot-add memory devices in memory ranges beyond 4 GB, PAE must be explicitly enabled.

    你可以看看你电脑的属性--常规,是否有”物理地址扩展“字样来确定是否开了PAE,不能只通过查看boot.ini确定,如果是en os,则为Physical Address Exension.
    2012年6月19日 2:46
  • 就目前你的问题,可以尝试的方法:

    1.单个分区分别建聚集

    2.如果你是<16GB内存,使用/3GB来增加 Bpool内的stolen内存大小到2.6GB.(我不确定是否有效,因为stolen和datapage会共享这2.6GB)

    3.改64位系统.

    期待你的测试结果。

    2012年6月19日 2:53

全部回复

  • 环境:windows2003sp2+sqlserver2008sp3

    CPU4核,8G物理内存,给SQLSERVER分配了最高使用5G,启用了AWE。

    表test_table为分区表,150万条记录。

    表test_table执行聚集索引创建时,报如下错误:

    “语句已终止。
    消息 701,级别 17,状态 123,第 1 行
    资源池 'default' 没有足够的系统内存来运行此查询。"

    CREATE CLUSTERED INDEX [IX_vdate] ON [dbo].[test_table]
    (
     [vdate] desc
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = ON, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [plan_vdate]([vdate])

    GO

    对于小的分区表操作是可以正常的,几个超过100万记录的表都会报同样的错误。

    尝试过重启SQLSERVER服务和服务器然后执行这个操作也失败。

    是不是需要调整SQLSERVER2008的什么参数才行?

    谢谢!


    你是32位操作系统吧?

    一般701的错误会有两种情况,一种是MemToLeave内存不足,一种是Bpool内的Stolen内存不足。

    你可以贴一下当时的log信息,可以通过xp_readerrorlog来获得。

    这样更准确定位。

    2012年6月15日 12:53
  • If it's 32-bit dedicated sql server, you can give sql 6gb memory.
    2012年6月15日 13:36
  • 6G还是这个错的,因为根本还没达到5G,就报错了。
    2012年6月16日 2:24
  • 2012-06-15 19:29:30.600 spid58  Failed allocate pages: FAIL_PAGE_ALLOCATION 1
    2012-06-15 19:29:30.600 spid58   Memory Manager         KB  --------       VM Reserved       1733384  VM Committed       145956  AWE Allocated            2678784  Reserved Memory             1024  Reserved Memory In Use         0
    2012-06-15 19:29:30.600 spid58   Memory node Id = 0            KB  --------       VM Reserved       1730568  VM Committed       143252  AWE Allocated            2678784  MultiPage Allocator            102920  SinglePage Allocator          1468224
    2012-06-15 19:29:30.600 spid58   Memory node Id = 32           KB  --------       VM Reserved          1728  VM Committed         1672  AWE Allocated           0  MultiPage Allocator         1600  SinglePage Allocator          1468224
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLGENERAL (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             1272  MultiPage Allocator         1504
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLBUFFERPOOL (node 0)          KB  --------       VM Reserved       1612472  VM Committed        30316  AWE Allocated            2678784  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator         2128
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLQUERYEXEC (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          1449136  MultiPage Allocator             89080
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLOPTIMIZER (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         120  MultiPage Allocator           72
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLUTILITIES (node 0)           KB  --------       VM Reserved           240  VM Committed          240  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          96  MultiPage Allocator            0
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLSTORENG (node 0)             KB  --------       VM Reserved          1152  VM Committed         1152  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             1816  MultiPage Allocator         3272
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLCONNECTIONPOOL (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         592  MultiPage Allocator            0
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLCLR (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         120  MultiPage Allocator          344
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLHTTP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SNI (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          56  MultiPage Allocator           16
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SNI (node 32)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           16
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SNI (Total)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          56  MultiPage Allocator           32
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_FULLTEXT (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          24  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SQLXP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SQLQERESERVATIONS (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2200  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_XE_BUFFER (node 0)       KB  --------       VM Reserved          4224  VM Committed         4224  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_HOST (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SOSNODE (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2408  MultiPage Allocator         5296
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SOSNODE (node 32)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator         1520
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SOSNODE (Total)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2424  MultiPage Allocator         6816
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_FULLTEXT_SHMEM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved            96  SM Committed           96  SinglePage Allocator           0  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_XE (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator           96
    2012-06-15 19:29:30.610 spid58   CACHESTORE_OBJCP (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         832  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_SQLCP (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         256  MultiPage Allocator          200
    2012-06-15 19:29:30.610 spid58   CACHESTORE_PHDR (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          24  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_XPROC (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_TEMPTABLES (node 0)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_NOTIF (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_VIEWDEFINITIONS (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_XMLDBTYPE (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_XMLDBELEMENT (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_XMLDBATTRIBUTE (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_STACKFRAMES (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            8
    2012-06-15 19:29:30.610 spid58   CACHESTORE_STACKFRAMES (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            8
    2012-06-15 19:29:30.610 spid58   CACHESTORE_STACKFRAMES (Total)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           16
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERTBLACS (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERKEK (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERDSH (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERUSERCERTLOOKUP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERRSB (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERREADONLY (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERTO (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_EVENTS (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_SYSTEMROWSET (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          72  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_CONVPRI (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_FULLTEXTSTOPLIST (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_SCHEMAMGR (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             5224  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_DBMETADATA (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         376  MultiPage Allocator           80
    2012-06-15 19:29:30.610 spid58   USERSTORE_TOKENPERM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         544  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_OBJPERM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         360  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_SXC (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_SXC (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_SXC (Total)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_LBSS (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          64  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SNI_PACKET (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         656  MultiPage Allocator           56
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SNI_PACKET (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           56
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SNI_PACKET (Total)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         656  MultiPage Allocator          112
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SERVICE_BROKER (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         400  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_LOCK_MANAGER (node 0)           KB  --------       VM Reserved          4096  VM Committed         4096  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             3272  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_LOCK_MANAGER (node 32)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          24  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_LOCK_MANAGER (Total)            KB  --------       VM Reserved          4096  VM Committed         4096  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             3296  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid74 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.610 spid74 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.610 spid55 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.610 spid55 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.610 spid79 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.610 spid79 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid77 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.620 spid77 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid70 错误: 701,严重性: 17,状态: 54。
    2012-06-15 19:29:30.620 spid70 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid54 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.620 spid54 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid67 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.620 spid67 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid63 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.620 spid63 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.630 spid59 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.630 spid59 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.610 spid68 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.610 spid68 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.630 spid87 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.630 spid87 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.630 spid69 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.630 spid69 There is insufficient system memory in resource pool 'default' to run this query.

    2012年6月16日 2:40
  • 2012-06-15 19:29:30.600 spid58  Failed allocate pages: FAIL_PAGE_ALLOCATION 1
    2012-06-15 19:29:30.600 spid58   Memory Manager         KB  --------       VM Reserved       1733384  VM Committed       145956  AWE Allocated            2678784  Reserved Memory             1024  Reserved Memory In Use         0
    2012-06-15 19:29:30.600 spid58   Memory node Id = 0            KB  --------       VM Reserved       1730568  VM Committed       143252  AWE Allocated            2678784  MultiPage Allocator            102920  SinglePage Allocator          1468224
    2012-06-15 19:29:30.600 spid58   Memory node Id = 32           KB  --------       VM Reserved          1728  VM Committed         1672  AWE Allocated           0  MultiPage Allocator         1600  SinglePage Allocator          1468224
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLGENERAL (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             1272  MultiPage Allocator         1504
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLBUFFERPOOL (node 0)          KB  --------       VM Reserved       1612472  VM Committed        30316  AWE Allocated            2678784  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator         2128
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLQUERYEXEC (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          1449136  MultiPage Allocator             89080
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLOPTIMIZER (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         120  MultiPage Allocator           72
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLUTILITIES (node 0)           KB  --------       VM Reserved           240  VM Committed          240  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          96  MultiPage Allocator            0
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLSTORENG (node 0)             KB  --------       VM Reserved          1152  VM Committed         1152  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             1816  MultiPage Allocator         3272
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLCONNECTIONPOOL (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         592  MultiPage Allocator            0
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLCLR (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         120  MultiPage Allocator          344
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLHTTP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SNI (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          56  MultiPage Allocator           16
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SNI (node 32)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           16
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SNI (Total)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          56  MultiPage Allocator           32
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_FULLTEXT (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          24  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SQLXP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SQLQERESERVATIONS (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2200  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_XE_BUFFER (node 0)       KB  --------       VM Reserved          4224  VM Committed         4224  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_HOST (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SOSNODE (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2408  MultiPage Allocator         5296
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SOSNODE (node 32)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator         1520
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SOSNODE (Total)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2424  MultiPage Allocator         6816
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_FULLTEXT_SHMEM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved            96  SM Committed           96  SinglePage Allocator           0  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   MEMORYCLERK_XE (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator           96
    2012-06-15 19:29:30.610 spid58   CACHESTORE_OBJCP (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         832  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_SQLCP (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         256  MultiPage Allocator          200
    2012-06-15 19:29:30.610 spid58   CACHESTORE_PHDR (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          24  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_XPROC (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_TEMPTABLES (node 0)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_NOTIF (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_VIEWDEFINITIONS (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_XMLDBTYPE (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_XMLDBELEMENT (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_XMLDBATTRIBUTE (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_STACKFRAMES (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            8
    2012-06-15 19:29:30.610 spid58   CACHESTORE_STACKFRAMES (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            8
    2012-06-15 19:29:30.610 spid58   CACHESTORE_STACKFRAMES (Total)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           16
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERTBLACS (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERKEK (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERDSH (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERUSERCERTLOOKUP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERRSB (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERREADONLY (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_BROKERTO (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_EVENTS (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_SYSTEMROWSET (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          72  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_CONVPRI (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   CACHESTORE_FULLTEXTSTOPLIST (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_SCHEMAMGR (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             5224  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_DBMETADATA (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         376  MultiPage Allocator           80
    2012-06-15 19:29:30.610 spid58   USERSTORE_TOKENPERM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         544  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_OBJPERM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         360  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_SXC (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_SXC (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   USERSTORE_SXC (Total)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_LBSS (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          64  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SNI_PACKET (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         656  MultiPage Allocator           56
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SNI_PACKET (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           56
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SNI_PACKET (Total)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         656  MultiPage Allocator          112
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SERVICE_BROKER (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         400  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_LOCK_MANAGER (node 0)           KB  --------       VM Reserved          4096  VM Committed         4096  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             3272  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_LOCK_MANAGER (node 32)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          24  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_LOCK_MANAGER (Total)            KB  --------       VM Reserved          4096  VM Committed         4096  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             3296  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid58   OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.610 spid74 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.610 spid74 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.610 spid55 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.610 spid55 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.610 spid79 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.610 spid79 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid77 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.620 spid77 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid70 错误: 701,严重性: 17,状态: 54。
    2012-06-15 19:29:30.620 spid70 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid54 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.620 spid54 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid67 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.620 spid67 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.620 spid63 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.620 spid63 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.630 spid59 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.630 spid59 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.610 spid68 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.610 spid68 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.630 spid87 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.630 spid87 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.630 spid69 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.630 spid69 There is insufficient system memory in resource pool 'default' to run this query.

    2012年6月16日 2:41
  • 2012-06-15 19:29:30.690 spid58   Buffer Pool         Value  --------       Committed          333920  Target             656512  Database           150212  Dirty           3240  In IO              0  Latched            1  Free             289  Stolen             183419  Reserved         266  Visible            192512  Stolen Potential            -798  Limiting Factor        10  Last OOM Factor         0  Last OS Error           0  Page Life Expectancy         480
    2012-06-15 19:29:30.690 spid58   Process/System Counts           Value  --------       Available Physical Memory           5044916224  Available Virtual Memory             238698496  Available Paging File        18587025408  Working Set             93634560  Percent of Committed Memory in WS          100  Page Faults         41277  System physical memory high         1  System physical memory low          0  Process physical memory low         1  Process virtual memory low          0
    2012-06-15 19:29:30.690 spid58   Procedure Cache            Value  --------       TotalProcs         0  TotalPages             59  InUsePages         0
    2012-06-15 19:29:30.690 spid58   Global Memory Objects           Pages  --------       Resource         194  Locks            412  XDES              50  SETLS              4  SE Dataset Allocators          8  SubpDesc Allocators            4  SE SchemaManager             395  SE Column Metadata Cache          249  SQLCache          32  Replication             2  ServerGlobal           27  XP Global          2  SortTables             35
    2012-06-15 19:29:30.690 spid58   Query Memory Objects (internal)          Value  --------       Grants             0  Waiting            0  Available            3875  Current Max          3875  Future Max           3875  Physical Max       144020  Next Request            0  Waiting For             0  Cost             0  Timeout            0  Wait Time          0
    2012-06-15 19:29:30.690 spid58   Small Query Memory Objects (internal)         Value  --------       Grants             0  Waiting            0  Available             640  Current Max           640  Future Max            640
    2012-06-15 19:29:30.690 spid58   Query Memory Objects (default)           Value  --------       Grants             1  Waiting            0  Available            3600  Current Max          3875  Future Max           3875  Physical Max       144020  Next Request            0  Waiting For             0  Cost             0  Timeout            0  Wait Time          0
    2012-06-15 19:29:30.690 spid58   Small Query Memory Objects (default)          Value  --------       Grants             0  Waiting            0  Available             640  Current Max           640  Future Max            640
    2012-06-15 19:29:30.690 spid58   Optimization Queue (internal)            Value  --------       Overall Memory             1264107520  Target Memory           39501824  Last Notification       0  Timeout            6  Early Termination Factor            5
    2012-06-15 19:29:30.690 spid58   Small Gateway (internal)          Value  --------       Configured Units       16  Available Units        16  Acquires           0  Waiters            0  Threshold Factor          250000  Threshold          250000
    2012-06-15 19:29:30.690 spid58   Medium Gateway (internal)         Value  --------       Configured Units        4  Available Units         4  Acquires           0  Waiters            0  Threshold Factor       12  Threshold         -1
    2012-06-15 19:29:30.690 spid58   Big Gateway (internal)          Value  --------       Configured Units        1  Available Units         1  Acquires           0  Waiters            0  Threshold Factor        8  Threshold         -1
    2012-06-15 19:29:30.690 spid58   Optimization Queue (default)             Value  --------       Overall Memory             1264107520  Target Memory         1051066368  Last Notification       2  Timeout            6  Early Termination Factor            5
    2012-06-15 19:29:30.690 spid58   Small Gateway (default)         Value  --------       Configured Units       16  Available Units        16  Acquires           0  Waiters            0  Threshold Factor          250000  Threshold          250000
    2012-06-15 19:29:30.690 spid58   Medium Gateway (default)          Value  --------       Configured Units        4  Available Units         4  Acquires           0  Waiters            0  Threshold Factor       12  Threshold         -1
    2012-06-15 19:29:30.690 spid58   Big Gateway (default)           Value  --------       Configured Units        1  Available Units         1  Acquires           0  Waiters            0  Threshold Factor        8  Threshold         -1
    2012-06-15 19:29:30.690 spid58   Memory Pool Manager             Pages  --------       Reserved Current             275  Reserved Limit        275
    2012-06-15 19:29:30.690 spid58   Memory Pool (internal)          Pages  --------       Allocations           930  Predicted             944  Private Target          0  Private Limit           0  Total Target       182886  Total Limit        182886  OOM Count          0
    2012-06-15 19:29:30.690 spid58   MEMORYBROKER_FOR_CACHE (internal)             Pages  --------       Allocations           404  Rate             4  Target Allocations          4822  Future Allocations             0  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.690 spid58   MEMORYBROKER_FOR_STEAL (internal)             Pages  --------       Allocations           526  Rate              10  Target Allocations          4822  Future Allocations             0  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.690 spid58   MEMORYBROKER_FOR_RESERVE (internal)           Pages  --------       Allocations             0  Rate             0  Target Allocations          4822  Future Allocations             0  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.690 spid58   Memory Pool (default)           Pages  --------       Allocations        182886  Predicted          225148  Private Target          0  Private Limit           0  Total Target       182886  Total Limit        182886  OOM Count             130
    2012-06-15 19:29:30.690 spid58   MEMORYBROKER_FOR_CACHE (default)         Pages  --------       Allocations          1148  Rate             -16  Target Allocations          4822  Future Allocations             0  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.690 spid58   MEMORYBROKER_FOR_STEAL (default)         Pages  --------       Allocations        181463  Rate            6532  Target Allocations             128304  Future Allocations             0  Overall            154310  Last Notification       2
    2012-06-15 19:29:30.690 spid58   MEMORYBROKER_FOR_RESERVE (default)            Pages  --------       Allocations           275  Rate             0  Target Allocations          4822  Future Allocations         36005  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.690 spid58 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.690 spid58 There is insufficient system memory in resource pool 'default' to run this query.

    2012年6月16日 2:44

  • 2012-06-15 19:29:30.960 spid23s   Memory Manager         KB  --------       VM Reserved       1733384  VM Committed       145956  AWE Allocated            2678784  Reserved Memory             1024  Reserved Memory In Use         0
    2012-06-15 19:29:30.960 spid23s   Memory node Id = 0            KB  --------       VM Reserved       1730568  VM Committed       143252  AWE Allocated            2678784  MultiPage Allocator            102920  SinglePage Allocator          1467256
    2012-06-15 19:29:30.960 spid23s   Memory node Id = 32           KB  --------       VM Reserved          1728  VM Committed         1672  AWE Allocated           0  MultiPage Allocator         1600  SinglePage Allocator          1467256
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLGENERAL (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             1272  MultiPage Allocator         1504
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLBUFFERPOOL (node 0)          KB  --------       VM Reserved       1612472  VM Committed        30316  AWE Allocated            2678784  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator         2128
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLQUERYEXEC (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          1449128  MultiPage Allocator             89080
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLOPTIMIZER (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         120  MultiPage Allocator           72
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLUTILITIES (node 0)           KB  --------       VM Reserved           240  VM Committed          240  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          96  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLSTORENG (node 0)             KB  --------       VM Reserved          1152  VM Committed         1152  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             1816  MultiPage Allocator         3272
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLCONNECTIONPOOL (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         592  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLCLR (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         120  MultiPage Allocator          344
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLHTTP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SNI (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          56  MultiPage Allocator           16
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SNI (node 32)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           16
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SNI (Total)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          56  MultiPage Allocator           32
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_FULLTEXT (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          24  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLXP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLQERESERVATIONS (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2200  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_XE_BUFFER (node 0)       KB  --------       VM Reserved          4224  VM Committed         4224  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_HOST (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SOSNODE (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2392  MultiPage Allocator         5296
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SOSNODE (node 32)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator         1520
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SOSNODE (Total)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             2408  MultiPage Allocator         6816
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_FULLTEXT_SHMEM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved            96  SM Committed           96  SinglePage Allocator           0  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   MEMORYCLERK_XE (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator           96
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_OBJCP (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_SQLCP (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         216  MultiPage Allocator          200
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_PHDR (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_XPROC (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_TEMPTABLES (node 0)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_NOTIF (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_VIEWDEFINITIONS (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_XMLDBTYPE (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_XMLDBELEMENT (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_XMLDBATTRIBUTE (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_STACKFRAMES (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            8
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_STACKFRAMES (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator            8
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_STACKFRAMES (Total)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           16
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_BROKERTBLACS (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_BROKERKEK (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_BROKERDSH (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_BROKERUSERCERTLOOKUP (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_BROKERRSB (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_BROKERREADONLY (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_BROKERTO (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_EVENTS (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_SYSTEMROWSET (node 0)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          72  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_CONVPRI (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   CACHESTORE_FULLTEXTSTOPLIST (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   USERSTORE_SCHEMAMGR (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             5160  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   USERSTORE_DBMETADATA (node 0)        KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         376  MultiPage Allocator           80
    2012-06-15 19:29:30.960 spid23s   USERSTORE_TOKENPERM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         544  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   USERSTORE_OBJPERM (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         360  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   USERSTORE_SXC (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          32  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   USERSTORE_SXC (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           8  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid87 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.960 spid87 There is insufficient system memory in resource pool 'default' to run this query.
    2012年6月16日 2:47
  • 2012-06-15 19:29:30.960 spid23s   USERSTORE_SXC (Total)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          40  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_LBSS (node 0)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          64  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_SNI_PACKET (node 0)             KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         656  MultiPage Allocator           56
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_SNI_PACKET (node 32)            KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator           0  MultiPage Allocator           56
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_SNI_PACKET (Total)       KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         656  MultiPage Allocator          112
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_SERVICE_BROKER (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator         400  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_LOCK_MANAGER (node 0)           KB  --------       VM Reserved          4096  VM Committed         4096  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             3272  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_LOCK_MANAGER (node 32)          KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          24  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_LOCK_MANAGER (Total)            KB  --------       VM Reserved          4096  VM Committed         4096  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator             3296  MultiPage Allocator            0
    2012-06-15 19:29:30.960 spid69 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.960 spid69 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.960 spid23s   OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0)         KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          16  MultiPage Allocator            0
    2012-06-15 19:29:30.960 服务器 Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
    2012-06-15 19:29:30.960 服务器 Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
    2012-06-15 19:29:30.960 spid74 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.960 spid74 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.960 spid79 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.960 spid79 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.960 spid70 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.960 spid70 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.960 spid59 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.960 spid59 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.960 spid63 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.960 spid63 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.960 spid67 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.960 spid67 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.970 spid58 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.970 spid58 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.970 spid74 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.970 spid74 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.970 spid68 错误: 701,严重性: 17,状态: 130。
    2012-06-15 19:29:30.970 spid68 There is insufficient system memory in resource pool 'default' to run this query.
    2012-06-15 19:29:30.970 spid23s   Buffer Pool         Value  --------       Committed          333920  Target             656512  Database           150212  Dirty           3240  In IO              0  Latched            1  Free             295  Stolen             183413  Reserved         266  Visible            192512  Stolen Potential            -792  Limiting Factor        10  Last OOM Factor        10  Last OS Error           0  Page Life Expectancy         481
    2012-06-15 19:29:30.980 spid23s   Process/System Counts           Value  --------       Available Physical Memory           5044695040  Available Virtual Memory             238698496  Available Paging File        18587054080  Working Set             93765632  Percent of Committed Memory in WS          100  Page Faults         41309  System physical memory high         1  System physical memory low          0  Process physical memory low         1  Process virtual memory low          0
    2012-06-15 19:29:30.980 spid23s   Procedure Cache            Value  --------       TotalProcs         0  TotalPages             56  InUsePages         0
    2012-06-15 19:29:30.980 spid23s   Global Memory Objects           Pages  --------       Resource         194  Locks            412  XDES              50  SETLS              4  SE Dataset Allocators          8  SubpDesc Allocators            4  SE SchemaManager             395  SE Column Metadata Cache          249  SQLCache          32  Replication             2  ServerGlobal           27  XP Global          2  SortTables             35
    2012-06-15 19:29:30.980 spid23s   Query Memory Objects (internal)          Value  --------       Grants             0  Waiting            0  Available            3875  Current Max          3875  Future Max           3875  Physical Max       144020  Next Request            0  Waiting For             0  Cost             0  Timeout            0  Wait Time          0
    2012-06-15 19:29:30.980 spid23s   Small Query Memory Objects (internal)         Value  --------       Grants             0  Waiting            0  Available             640  Current Max           640  Future Max            640
    2012-06-15 19:29:30.980 spid23s   Query Memory Objects (default)           Value  --------       Grants             1  Waiting            0  Available            3600  Current Max          3875  Future Max           3875  Physical Max       144020  Next Request            0  Waiting For             0  Cost             0  Timeout            0  Wait Time          0
    2012-06-15 19:29:30.980 spid23s   Small Query Memory Objects (default)          Value  --------       Grants             0  Waiting            0  Available             640  Current Max           640  Future Max            640
    2012-06-15 19:29:30.980 spid23s   Optimization Queue (internal)            Value  --------       Overall Memory             1264107520  Target Memory           39501824  Last Notification       0  Timeout            6  Early Termination Factor            5
    2012-06-15 19:29:30.980 spid23s   Small Gateway (internal)          Value  --------       Configured Units       16  Available Units        16  Acquires           0  Waiters            0  Threshold Factor          250000  Threshold          250000
    2012-06-15 19:29:30.980 spid23s   Medium Gateway (internal)         Value  --------       Configured Units        4  Available Units         4  Acquires           0  Waiters            0  Threshold Factor       12  Threshold         -1
    2012-06-15 19:29:30.980 spid23s   Big Gateway (internal)          Value  --------       Configured Units        1  Available Units         1  Acquires           0  Waiters            0  Threshold Factor        8  Threshold         -1
    2012-06-15 19:29:30.980 spid23s   Optimization Queue (default)             Value  --------       Overall Memory             1264107520  Target Memory         1049714688  Last Notification       2  Timeout            6  Early Termination Factor            5
    2012-06-15 19:29:30.980 spid23s   Small Gateway (default)         Value  --------       Configured Units       16  Available Units        16  Acquires           0  Waiters            0  Threshold Factor          250000  Threshold          250000
    2012-06-15 19:29:30.980 spid23s   Medium Gateway (default)          Value  --------       Configured Units        4  Available Units         4  Acquires           0  Waiters            0  Threshold Factor       12  Threshold         -1
    2012-06-15 19:29:30.980 spid23s   Big Gateway (default)           Value  --------       Configured Units        1  Available Units         1  Acquires           0  Waiters            0  Threshold Factor        8  Threshold         -1
    2012-06-15 19:29:30.980 spid23s   Memory Pool Manager             Pages  --------       Reserved Current             275  Reserved Limit        275
    2012-06-15 19:29:30.980 spid23s   Memory Pool (internal)          Pages  --------       Allocations           936  Predicted            1006  Private Target          0  Private Limit           0  Total Target       182886  Total Limit        182886  OOM Count          0
    2012-06-15 19:29:30.980 spid23s   MEMORYBROKER_FOR_CACHE (internal)             Pages  --------       Allocations           405  Rate              13  Target Allocations          4822  Future Allocations             0  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.980 spid23s   MEMORYBROKER_FOR_STEAL (internal)             Pages  --------       Allocations           531  Rate              57  Target Allocations          4822  Future Allocations             0  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.980 spid23s   MEMORYBROKER_FOR_RESERVE (internal)           Pages  --------       Allocations             0  Rate             0  Target Allocations          4822  Future Allocations             0  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.980 spid23s   Memory Pool (default)           Pages  --------       Allocations        182765  Predicted          223344  Private Target          0  Private Limit           0  Total Target       182886  Total Limit        182886  OOM Count             130
    2012-06-15 19:29:30.980 spid23s   MEMORYBROKER_FOR_CACHE (default)         Pages  --------       Allocations          1032  Rate           -1172  Target Allocations          4822  Future Allocations             0  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.980 spid23s   MEMORYBROKER_FOR_STEAL (default)         Pages  --------       Allocations        181458  Rate            4849  Target Allocations             128139  Future Allocations             0  Overall            154310  Last Notification       2
    2012-06-15 19:29:30.980 spid23s   MEMORYBROKER_FOR_RESERVE (default)            Pages  --------       Allocations           275  Rate             0  Target Allocations          4822  Future Allocations         36005  Overall            154310  Last Notification       0
    2012-06-15 19:29:30.980 spid77 错误: 701,严重性: 17,状态: 123。
    2012-06-15 19:29:30.980 spid77 There is insufficient system memory in resource pool 'default' to run this query.
    2012年6月16日 2:49
  • 从你提供的log信息可以看到:

    2012-06-15 19:29:30.600 spid58  Failed allocate pages: FAIL_PAGE_ALLOCATION 1
    2012-06-15 19:29:30.600 spid58   MEMORYCLERK_SQLQUERYEXEC (node 0)           KB  --------       VM Reserved             0  VM Committed            0  AWE Allocated           0  SM Reserved             0  SM Committed            0  SinglePage Allocator          1449136  MultiPage Allocator             89080

    FAIL_PAGE_ALLOCATION 1 标明Buffer pool内的stolen内存不足,这部分内存最大的占用者是MEMORYCLERK_SQLQUERYEXEC.

    从字面上分析,应该是在SQL执行时,需要用到很大的内存,当你在创建聚集索引时申请的内存大于1449136KB,而此时已没有可用的内存供分配,所以报错。
    MEMORYCLERK_SQLQUERYEXEC这块的内存我不确定是否可以通过语句来释放,但估计不可以,你可以常试不停的清除掉其它stoten内存来试试:
    DBCC FREESYSTEMCACHE
    DBCC FREESESSIONCACHE
    DBCC FREEPROCCACHE
    ps:在32位系统中,除去MemtoLeave内存外,buffer pool可用的stolen内存只有1.6GB左右,所以针对你的问题,升级到x64位是最佳方案。

    2012年6月16日 8:13
  • 创建操作一直在进行着的同时,做DBCC FREESYSTEMCACHE
    DBCC FREESESSIONCACHE
    DBCC FREEPROCCACHE这样的操作?估计有问题吧。

    看来32系统对于大数据量的索引创建都是个难题?

    2012年6月16日 8:32
  • 但是我分配给SQLSERVER5G内存,才用到3G就报错了。
    2012年6月16日 8:34
  • 但是我分配给SQLSERVER5G内存,才用到3G就报错了。
    你没有理解,在32位中,buffer pool中的stolen内存是无法超过1.6GB的,AWE只能扩展buffer pool中的data page这部分。你分配给SQL的内存,只不过是增大了data page,无法增大stolen内存。
    2012年6月16日 8:41
  • 创建操作一直在进行着的同时,做DBCC FREESYSTEMCACHE
    DBCC FREESESSIONCACHE
    DBCC FREEPROCCACHE这样的操作?估计有问题吧。

    看来32系统对于大数据量的索引创建都是个难题?

    如果是分区表,你可以试试每个分区分别创建索引,对内存的申请应该会有减小。
    2012年6月16日 9:04
  • 但是我分配给SQLSERVER5G内存,才用到3G就报错了。
    你没有理解,在32位中,buffer pool中的stolen内存是无法超过1.6GB的,AWE只能扩展buffer pool中的data page这部分。你分配给SQL的内存,只不过是增大了data page,无法增大stolen内存。
    Not just stolen part, sql can only use 1.6gb for everything except data cache on 32-bit machine. Can put /3gb in boot.ini file, that'll give one more gb memory to sql for procedure cache and so.
    2012年6月16日 16:40
  • 创建操作一直在进行着的同时,做DBCC FREESYSTEMCACHE
    DBCC FREESESSIONCACHE
    DBCC FREEPROCCACHE这样的操作?估计有问题吧。

    看来32系统对于大数据量的索引创建都是个难题?

    如果是分区表,你可以试试每个分区分别创建索引,对内存的申请应该会有减小。
    Possible if only query specific partition.
    2012年6月16日 16:41
  • 有几个问题顺便也在这里请教一下哈。

    1 MEMORYCLERK_SQLQUERYEXEC 那个CLERK是为哪些对象分配内存的呀,那些内存的占有者有哪些呀?GOOGLR了好久没有找到那方面的资料

    2 “FAIL_PAGE_ALLOCATION 1 标明Buffer pool内的stolen内存不足”这是依据什么来判断的?也就是说,为什么判断index操作用的是Buffer pool内的stolen,而不是MTL中的内存呢?

    3 "Not just stolen part, sql can only use 1.6gb for everything except data cache on 32-bit machine. "这个1.6gb 应该是指除去MTL的那部分吧?你说的for everything except data cache ,也就是说Extended Procedures, COM objects (OLE Automation calls), Linked Servers, OLEDB providers, SQL CLR 等对象也放在这个1.6G里面吗?





    2012年6月17日 4:19
  • 当前SQLSERVER数据库已经可以用到5G的, 在boot.ini里添加/3g开关没意义吧?


    • 已编辑 guaranty 2012年6月17日 5:02
    2012年6月17日 5:02
  • 有几个问题顺便也在这里请教一下哈。

    1 MEMORYCLERK_SQLQUERYEXEC 那个CLERK是为哪些对象分配内存的呀,那些内存的占有者有哪些呀?GOOGLR了好久没有找到那方面的资料

    2 “FAIL_PAGE_ALLOCATION 1 标明Buffer pool内的stolen内存不足”这是依据什么来判断的?也就是说,为什么判断index操作用的是Buffer pool内的stolen,而不是MTL中的内存呢?

    3 "Not just stolen part, sql can only use 1.6gb for everything except data cache on 32-bit machine. "这个1.6gb 应该是指除去MTL的那部分吧?你说的for everything except data cache ,也就是说Extended Procedures, COM objects (OLE Automation calls), Linked Servers, OLEDB providers, SQL CLR 等对象也放在这个1.6G里面吗?





    1.没找到资料.

    2.701错误都是针对Stolen Memory,分为两种,一种是buffer pool内的stolen不足,它的申请单位会是page,现象:Failed allocate pages:FAIL_PAGE_ALLOCATION ,在楼主的case中,就是这个,并且可以从日志信息中的SinglePage Allocator  1449136KB得到印证,不过此处的MultiPage Allocator   89080KB也很大了不,但首先反应出来的是SinglePage不足,如果是MTL不足,错误信息会是:Failed Virtual Allocate Bytes:FAIL_VIRTUAL_RESERVE xx,相对应的MultiPage 可能会超过100MB+。
    so,FAIL_PAGE_ALLOCATION 表明是bpool内stolen不足,FAIL_VIRTUAL_RESERVE表明Memtoleave不足,前者后面数值单位是page,第二种后面的数值单位是bytes.
    而且也可以通过下面的代码来查看可连申请的最大MemToLeave内存是否不足:

    WITH VAS_Summary
    AS (
    SELECT
    Size = VAS_Dump.Size,
    Reserved =
    SUM(CASE(CONVERT(INT, VAS_Dump.Base) ^ 0)
    WHEN 0 THEN 0
    ELSE 1
    END),
    Free =
    SUM(CASE(CONVERT(INT, VAS_Dump.Base) ^ 0)
    WHEN 0 THEN 1
    ELSE 0
    END)
    FROM
    (
    SELECT
    CONVERT(VARBINARY, SUM(region_size_in_bytes)) [Size],
    region_allocation_base_address [Base]
    FROM sys.dm_os_virtual_address_dump
    WHERE region_allocation_base_address <> 0x0
    GROUP BY region_allocation_base_address
    UNION
    SELECT
    CONVERT(VARBINARY, region_size_in_bytes) [Size],
    region_allocation_base_address [Base]
    FROM   sys.dm_os_virtual_address_dump
    WHERE  region_allocation_base_address = 0x0
    ) AS VAS_Dump
    GROUP BY Size
    )
    SELECT
    SUM(CONVERT(BIGINT, Size) * Free) / 1024 AS [Total avail mem, KB],
    CAST(MAX(Size) AS BIGINT) / 1024 AS [Max free size, KB]
    FROM VAS_Summary
    WHERE Free <> 0

    3.你说的Extended Procedures, COM objects (OLE Automation calls), Linked Servers, OLEDB providers, SQL CLR 应该是申请MTL内存,不在那1.6gb中。

    2012年6月17日 7:14
  • @nicofer

    嗯,十分感谢,也基本同意你的观点。

    关于 “错误信息会是:Failed Virtual Allocate Bytes:FAIL_VIRTUAL_RESERVE xx,相对应的MultiPage 可能会超过100MB+”,因为MTL 除了存放MultiPage外,还有存放COM objects (OLE Automation calls), Linked Servers, OLEDB providers, SQL CLR ,所以,如果是后者泄漏的话,那MultiPage 就不一定超过100M,或者说很大,这时候要看具体是哪个东西(COM objects (OLE Automation calls), Linked Servers, OLEDB providers, SQL CLR )泄漏了,当然你是说可能会超过,肯定是对的。

    2012年6月17日 7:49
  • @nicofer

    嗯,十分感谢,也基本同意你的观点。

    关于 “错误信息会是:Failed Virtual Allocate Bytes:FAIL_VIRTUAL_RESERVE xx,相对应的MultiPage 可能会超过100MB+”,因为MTL 除了存放MultiPage外,还有存放COM objects (OLE Automation calls), Linked Servers, OLEDB providers, SQL CLR ,所以,如果是后者泄漏的话,那MultiPage 就不一定超过100M,或者说很大,这时候要看具体是哪个东西(COM objects (OLE Automation calls), Linked Servers, OLEDB providers, SQL CLR )泄漏了,当然你是说可能会超过,肯定是对的。

    Hi jacky, MTL内存不足还要分为两种,一种是上面所说的,能够通过log信息或者sys.dm_os_memory_clerks查看到的MultiPage,这部分如果找到是什么消耗的可以有相应的办法,还有一种就是第三方代码或者是Windows本身造成的,这个很难分析,我们曾经遇到过一个频繁备份log造成的MemToLeave碎片化问题,导致MemToLeave不足,只有重新sql server service才能解决,而这个是通过sql server本身无法定位问题,需要长期实时监控windows内存分配。

    以前我经常看的一篇文章:http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/16/how-to-find-who-is-using-eating-up-the-virtual-address-space-on-your-sql-server.aspx

    2012年6月17日 8:14
  • @nicofer

    十分感谢,受益匪浅。 


    2012年6月17日 9:31
  • 有几个问题顺便也在这里请教一下哈。

    1 MEMORYCLERK_SQLQUERYEXEC 那个CLERK是为哪些对象分配内存的呀,那些内存的占有者有哪些呀?GOOGLR了好久没有找到那方面的资料

    2 “FAIL_PAGE_ALLOCATION 1 标明Buffer pool内的stolen内存不足”这是依据什么来判断的?也就是说,为什么判断index操作用的是Buffer pool内的stolen,而不是MTL中的内存呢?

    3 "Not just stolen part, sql can only use 1.6gb for everything except data cache on 32-bit machine. "这个1.6gb 应该是指除去MTL的那部分吧?你说的for everything except data cache ,也就是说Extended Procedures, COM objects (OLE Automation calls), Linked Servers, OLEDB providers, SQL CLR 等对象也放在这个1.6G里面吗?





    For 3, those are outside of sql.
    2012年6月17日 19:55
  • 当前SQLSERVER数据库已经可以用到5G的, 在boot.ini里添加/3g开关没意义吧?


    Sql can use up to 7gb memory after adding /3g, more important can use up to 2.6gb base memory.
    2012年6月17日 19:57
  • windows2003x86企业版支持32G内存的。从没有添加/PAE和/3GB这样的参数。

    我有的机器,没添加/3GB参数,SQLSERVER也可以用到10G以上的,分多少就可以用多少,所以应该是没关系的。

    2012年6月18日 3:08
  • Can't add /3g if machine has 16gb or more memory, sql can't use memory above 4gb range on 32-bit machine if no /pae in boot.ini file.
    2012年6月18日 3:36
  • 当然可以呀,呵呵,好几台机器都证明了。没有添加/PAE完全可以用到16G内存。
    2012年6月18日 6:42
  • On 32-bit machine? MS should learn something from you then.
    2012年6月18日 13:14
  • 当然可以呀,呵呵,好几台机器都证明了。没有添加/PAE完全可以用到16G内存。
    Windows automatically enables PAE if DEP is enabled on a computer that supports hardware-enabled DEP, or if the computer is configured for hot-add memory devices in memory ranges beyond 4 GB. If the computer does not support hardware-enabled DEP or is not configured for hot-add memory devices in memory ranges beyond 4 GB, PAE must be explicitly enabled.

    你可以看看你电脑的属性--常规,是否有”物理地址扩展“字样来确定是否开了PAE,不能只通过查看boot.ini确定,如果是en os,则为Physical Address Exension.
    2012年6月19日 2:46
  • 就目前你的问题,可以尝试的方法:

    1.单个分区分别建聚集

    2.如果你是<16GB内存,使用/3GB来增加 Bpool内的stolen内存大小到2.6GB.(我不确定是否有效,因为stolen和datapage会共享这2.6GB)

    3.改64位系统.

    期待你的测试结果。

    2012年6月19日 2:53