sqlserver2008内存问题求助 sqlserver内存701 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 12/19/2014 13:06:52,spid213,Unknown,There is insufficient system memory in resource pool 'default' to run this query.12/19/2014 13:06:52,spid213,Unknown,Error: 701<c/> Severity: 17<c/> State: 123.12/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_RESERVE (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 1280<nl/>Rate 10465<nl/>Target Allocations 5116375<nl/>Future Allocations 1139191<nl/>Overall 5116375<nl/>Last Notification 112/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_STEAL (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 5422<nl/>Rate -436<nl/>Target Allocations 4897472<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 112/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_CACHE (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 20372<nl/>Rate 0<nl/>Target Allocations 4912422<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 112/19/2014 13:01:24,spid390,Unknown,Memory Pool (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 27074<nl/>Predicted 1164985<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 6063853<nl/>Total Limit 6063853<nl/>OOM Count 012/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_RESERVE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 0<nl/>Rate 0<nl/>Target Allocations 4892050<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 112/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_STEAL (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 3456<nl/>Rate 0<nl/>Target Allocations 4895506<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 112/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_CACHE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 3362<nl/>Rate 0<nl/>Target Allocations 4895412<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 112/19/2014 13:01:24,spid390,Unknown,Memory Pool (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 6818<nl/>Predicted 6818<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 6063853<nl/>Total Limit 6063853<nl/>OOM Count 012/19/2014 13:01:24,spid390,Unknown,Memory Pool Manager Pages<nl/>---------------------------------------- ----------<nl/>Reserved Current 0<nl/>Reserved Limit 603124112/19/2014 13:01:24,spid390,Unknown,Big Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1<nl/>Available Units 1<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 8<nl/>Threshold -112/19/2014 13:01:24,spid390,Unknown,Medium Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 64<nl/>Available Units 64<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold -112/19/2014 13:01:24,spid390,Unknown,Small Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 256<nl/>Available Units 256<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 380000<nl/>Threshold 38000012/19/2014 13:01:24,spid390,Unknown,Optimization Queue (default) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 41913344000<nl/>Target Memory 40120090624<nl/>Last Notification 1<nl/>Timeout 6<nl/>Early Termination Factor 512/19/2014 13:01:24,spid390,Unknown,Big Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1<nl/>Available Units 1<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 8<nl/>Threshold -112/19/2014 13:01:24,spid390,Unknown,Medium Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 64<nl/>Available Units 64<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold -112/19/2014 13:01:24,spid390,Unknown,Small Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 256<nl/>Available Units 256<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 380000<nl/>Threshold 38000012/19/2014 13:01:24,spid390,Unknown,Optimization Queue (internal) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 41913344000<nl/>Target Memory 40103985152<nl/>Last Notification 1<nl/>Timeout 6<nl/>Early Termination Factor 5 12/19/2014 13:01:24,spid390,Unknown,Small Query Memory Objects (default) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 239829<nl/>Current Max 239829<nl/>Future Max 23982912/19/2014 13:01:24,spid390,Unknown,Query Memory Objects (default) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 4556766<nl/>Current Max 4556766<nl/>Future Max 4556766<nl/>Physical Max 4556766<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 012/19/2014 13:01:24,spid390,Unknown,Small Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 229314<nl/>Current Max 229314<nl/>Future Max 22931412/19/2014 13:01:24,spid390,Unknown,Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 4356981<nl/>Current Max 4356981<nl/>Future Max 4356981<nl/>Physical Max 4567281<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 012/19/2014 13:01:24,spid390,Unknown,Global Memory Objects Pages<nl/>---------------------------------------- ----------<nl/>Resource 276<nl/>Locks 531<nl/>XDES 845<nl/>SETLS 64<nl/>SE Dataset Allocators 128<nl/>SubpDesc Allocators 64<nl/>SE SchemaManager 1538<nl/>SE Column Metadata Cache 227<nl/>SQLCache 245<nl/>Replication 2<nl/>ServerGlobal 50<nl/>XP Global 2<nl/>SortTables 212/19/2014 13:01:24,spid390,Unknown,Procedure Cache Value<nl/>---------------------------------------- ----------<nl/>TotalProcs 221<nl/>TotalPages 19657<nl/>InUsePages 1324112/19/2014 13:01:24,spid390,Unknown,Process/System Counts Value<nl/>---------------------------------------- ----------<nl/>Available Physical Memory 2243268608<nl/>Available Virtual Memory 8725469650944<nl/>Available Paging File 15253504<nl/>Working Set 54040526848<nl/>Percent of Committed Memory in WS 100<nl/>Page Faults 22989808<nl/>System physical memory high 1<nl/>System physical memory low 0<nl/>Process physical memory low 0<nl/>Process virtual memory low 012/19/2014 13:01:24,spid390,Unknown,Buffer Pool Value<nl/>---------------------------------------- ----------<nl/>Committed 6381143<nl/>Target 6383004<nl/>Database 5001947<nl/>Dirty 146526<nl/>In IO 0<nl/>Latched 0<nl/>Free 862100<nl/>Stolen 32613<nl/>Reserved 0<nl/>Visible 6383004<nl/>Stolen Potential 6031241<nl/>Limiting Factor 18<nl/>Last OOM Factor 0<nl/>Page Life Expectancy 16612/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 131076<nl/>VM Committed 131076<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4248<nl/>MultiPage Allocator 012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 3) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1000<nl/>MultiPage Allocator 012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 2) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1000<nl/>MultiPage Allocator 012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1000<nl/>MultiPage Allocator 012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 131076<nl/>VM Committed 131076<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1224<nl/>MultiPage Allocator 012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SERVICE_BROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 424<nl/>MultiPage Allocator 012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 12896<nl/>MultiPage Allocator 28012/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 5612/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 3) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3176<nl/>MultiPage Allocator 5612/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 2) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3232<nl/>MultiPage Allocator 5612/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3304<nl/>MultiPage Allocator 5612/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3184<nl/>MultiPage Allocator 5612/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 384<nl/>MultiPage Allocator 83212/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (node 3) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 96<nl/>MultiPage Allocator 22412/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (node 2) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 80<nl/>MultiPage Allocator 14412/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 128<nl/>MultiPage Allocator 27212/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 80<nl/>MultiPage Allocator 19212/19/2014 13:01:23,spid390,Unknown,USERSTORE_SXC (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator mssql的内存管理 还是相当让人省心的会出现分配失败?它会自动把近期不用的数据占的内存腾出来,难道都不够用? log太大了,没贴完,又不能上传附件,郁闷呐 http://u.download.csdn.net/upload 在这边上传然后把链接贴出来 错误日志在这里:http://download.csdn.net/detail/typhoon1997/8278453 基本都被bufferpool全部占掉了,数据库有多大,看能不能优化语句 试试这个:dbcc freeproccache 关于SQL行列转换的问题 空格分隔问题 如何处理单头和单据内容同步的问题 SQL Server 2008的安装问题 郁闷!行号问题,88分,马上结帐!!!!!!!!!!!! 问个SQL怎么写~用子查询避开聚类函数。(可给100!!!!!!!!!!!!!) 100分有没有人敢要! 主键、主关键字、索引的区别是什么? 175个字段的表的问题.如何解决呢.一个表中容不下,难不诚还要两张表 vb6可不可以用msde作为本地数据库,本地连接串怎么写?下午一点的飞机赶着去测试,急死了! mssql 2005查询速度非常慢 数据表首次更新操作极慢,但重启后又很快
12/19/2014 13:06:52,spid213,Unknown,Error: 701<c/> Severity: 17<c/> State: 123.
12/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_RESERVE (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 1280<nl/>Rate 10465<nl/>Target Allocations 5116375<nl/>Future Allocations 1139191<nl/>Overall 5116375<nl/>Last Notification 1
12/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_STEAL (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 5422<nl/>Rate -436<nl/>Target Allocations 4897472<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 1
12/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_CACHE (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 20372<nl/>Rate 0<nl/>Target Allocations 4912422<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 1
12/19/2014 13:01:24,spid390,Unknown,Memory Pool (default) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 27074<nl/>Predicted 1164985<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 6063853<nl/>Total Limit 6063853<nl/>OOM Count 0
12/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_RESERVE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 0<nl/>Rate 0<nl/>Target Allocations 4892050<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 1
12/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_STEAL (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 3456<nl/>Rate 0<nl/>Target Allocations 4895506<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 1
12/19/2014 13:01:24,spid390,Unknown,MEMORYBROKER_FOR_CACHE (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 3362<nl/>Rate 0<nl/>Target Allocations 4895412<nl/>Future Allocations 0<nl/>Overall 5116375<nl/>Last Notification 1
12/19/2014 13:01:24,spid390,Unknown,Memory Pool (internal) Pages<nl/>---------------------------------------- ----------<nl/>Allocations 6818<nl/>Predicted 6818<nl/>Private Target 0<nl/>Private Limit 0<nl/>Total Target 6063853<nl/>Total Limit 6063853<nl/>OOM Count 0
12/19/2014 13:01:24,spid390,Unknown,Memory Pool Manager Pages<nl/>---------------------------------------- ----------<nl/>Reserved Current 0<nl/>Reserved Limit 6031241
12/19/2014 13:01:24,spid390,Unknown,Big Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1<nl/>Available Units 1<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 8<nl/>Threshold -1
12/19/2014 13:01:24,spid390,Unknown,Medium Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 64<nl/>Available Units 64<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold -1
12/19/2014 13:01:24,spid390,Unknown,Small Gateway (default) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 256<nl/>Available Units 256<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 380000<nl/>Threshold 380000
12/19/2014 13:01:24,spid390,Unknown,Optimization Queue (default) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 41913344000<nl/>Target Memory 40120090624<nl/>Last Notification 1<nl/>Timeout 6<nl/>Early Termination Factor 5
12/19/2014 13:01:24,spid390,Unknown,Big Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 1<nl/>Available Units 1<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 8<nl/>Threshold -1
12/19/2014 13:01:24,spid390,Unknown,Medium Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 64<nl/>Available Units 64<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 12<nl/>Threshold -1
12/19/2014 13:01:24,spid390,Unknown,Small Gateway (internal) Value<nl/>---------------------------------------- ----------<nl/>Configured Units 256<nl/>Available Units 256<nl/>Acquires 0<nl/>Waiters 0<nl/>Threshold Factor 380000<nl/>Threshold 380000
12/19/2014 13:01:24,spid390,Unknown,Optimization Queue (internal) Value<nl/>---------------------------------------- ----------<nl/>Overall Memory 41913344000<nl/>Target Memory 40103985152<nl/>Last Notification 1<nl/>Timeout 6<nl/>Early Termination Factor 5
12/19/2014 13:01:24,spid390,Unknown,Query Memory Objects (default) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 4556766<nl/>Current Max 4556766<nl/>Future Max 4556766<nl/>Physical Max 4556766<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 0
12/19/2014 13:01:24,spid390,Unknown,Small Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 229314<nl/>Current Max 229314<nl/>Future Max 229314
12/19/2014 13:01:24,spid390,Unknown,Query Memory Objects (internal) Value<nl/>---------------------------------------- ----------<nl/>Grants 0<nl/>Waiting 0<nl/>Available 4356981<nl/>Current Max 4356981<nl/>Future Max 4356981<nl/>Physical Max 4567281<nl/>Next Request 0<nl/>Waiting For 0<nl/>Cost 0<nl/>Timeout 0<nl/>Wait Time 0
12/19/2014 13:01:24,spid390,Unknown,Global Memory Objects Pages<nl/>---------------------------------------- ----------<nl/>Resource 276<nl/>Locks 531<nl/>XDES 845<nl/>SETLS 64<nl/>SE Dataset Allocators 128<nl/>SubpDesc Allocators 64<nl/>SE SchemaManager 1538<nl/>SE Column Metadata Cache 227<nl/>SQLCache 245<nl/>Replication 2<nl/>ServerGlobal 50<nl/>XP Global 2<nl/>SortTables 2
12/19/2014 13:01:24,spid390,Unknown,Procedure Cache Value<nl/>---------------------------------------- ----------<nl/>TotalProcs 221<nl/>TotalPages 19657<nl/>InUsePages 13241
12/19/2014 13:01:24,spid390,Unknown,Process/System Counts Value<nl/>---------------------------------------- ----------<nl/>Available Physical Memory 2243268608<nl/>Available Virtual Memory 8725469650944<nl/>Available Paging File 15253504<nl/>Working Set 54040526848<nl/>Percent of Committed Memory in WS 100<nl/>Page Faults 22989808<nl/>System physical memory high 1<nl/>System physical memory low 0<nl/>Process physical memory low 0<nl/>Process virtual memory low 0
12/19/2014 13:01:24,spid390,Unknown,Buffer Pool Value<nl/>---------------------------------------- ----------<nl/>Committed 6381143<nl/>Target 6383004<nl/>Database 5001947<nl/>Dirty 146526<nl/>In IO 0<nl/>Latched 0<nl/>Free 862100<nl/>Stolen 32613<nl/>Reserved 0<nl/>Visible 6383004<nl/>Stolen Potential 6031241<nl/>Limiting Factor 18<nl/>Last OOM Factor 0<nl/>Page Life Expectancy 166
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 16<nl/>MultiPage Allocator 0
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 131076<nl/>VM Committed 131076<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 4248<nl/>MultiPage Allocator 0
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 24<nl/>MultiPage Allocator 0
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 3) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1000<nl/>MultiPage Allocator 0
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 2) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1000<nl/>MultiPage Allocator 0
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 1)
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LOCK_MANAGER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 131076<nl/>VM Committed 131076<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 1224<nl/>MultiPage Allocator 0
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SERVICE_BROKER (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 424<nl/>MultiPage Allocator 0
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 12896<nl/>MultiPage Allocator 280
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 64) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 0<nl/>MultiPage Allocator 56
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 3) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3176<nl/>MultiPage Allocator 56
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 2) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3232<nl/>MultiPage Allocator 56
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3304<nl/>MultiPage Allocator 56
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_SNI_PACKET (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 3184<nl/>MultiPage Allocator 56
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 384<nl/>MultiPage Allocator 832
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (node 3) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 96<nl/>MultiPage Allocator 224
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (node 2) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 80<nl/>MultiPage Allocator 144
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (node 1) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 128<nl/>MultiPage Allocator 272
12/19/2014 13:01:23,spid390,Unknown,OBJECTSTORE_LBSS (node 0) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator 80<nl/>MultiPage Allocator 192
12/19/2014 13:01:23,spid390,Unknown,USERSTORE_SXC (Total) KB<nl/>---------------------------------------- ----------<nl/>VM Reserved 0<nl/>VM Committed 0<nl/>Locked Pages Allocated 0<nl/>SM Reserved 0<nl/>SM Committed 0<nl/>SinglePage Allocator
会出现分配失败?它会自动把近期不用的数据占的内存腾出来,难道都不够用?
dbcc freeproccache