积极答复者
资源池 'default' 没有足够的系统内存来运行此查询。

问题
-
环境: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
答案
-
当然可以呀,呵呵,好几台机器都证明了。没有添加/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.- 已标记为答案 Molly Chen_Moderator 2012年6月26日 1:54
-
就目前你的问题,可以尝试的方法:
1.单个分区分别建聚集
2.如果你是<16GB内存,使用/3GB来增加 Bpool内的stolen内存大小到2.6GB.(我不确定是否有效,因为stolen和datapage会共享这2.6GB)
3.改64位系统.
期待你的测试结果。- 已标记为答案 Molly Chen_Moderator 2012年6月26日 1:54
全部回复
-
环境: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-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-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-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-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-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. -
从你提供的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 89080FAIL_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位是最佳方案。
-
但是我分配给SQLSERVER5G内存,才用到3G就报错了。
你没有理解,在32位中,buffer pool中的stolen内存是无法超过1.6GB的,AWE只能扩展buffer pool中的data page这部分。你分配给SQL的内存,只不过是增大了data page,无法增大stolen内存。
-
有几个问题顺便也在这里请教一下哈。
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里面吗?
- 已编辑 Jacky_shen 2012年6月17日 4:46
-
有几个问题顺便也在这里请教一下哈。
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中。
-
嗯,十分感谢,也基本同意你的观点。
关于 “错误信息会是: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 )泄漏了,当然你是说可能会超过,肯定是对的。
- 已编辑 Jacky_shen 2012年6月17日 7:52
-
嗯,十分感谢,也基本同意你的观点。
关于 “错误信息会是: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内存分配。
-
有几个问题顺便也在这里请教一下哈。
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里面吗?
-
当然可以呀,呵呵,好几台机器都证明了。没有添加/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.- 已标记为答案 Molly Chen_Moderator 2012年6月26日 1:54
-
就目前你的问题,可以尝试的方法:
1.单个分区分别建聚集
2.如果你是<16GB内存,使用/3GB来增加 Bpool内的stolen内存大小到2.6GB.(我不确定是否有效,因为stolen和datapage会共享这2.6GB)
3.改64位系统.
期待你的测试结果。- 已标记为答案 Molly Chen_Moderator 2012年6月26日 1:54