Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Insufficient system memory in resourcepool 'defaul

Author  Topic  ravikn76 Starting Member 1 Post Posted - 2011-05-27 : 03:44:09 Hi, We have a SQL Server 2008 R2(version 10.50.1600.1) which is a dev database where a number of applications(over 100 connections at any instance) report data to. We often get the below error and all the inserts fail. Can anybody please recommend any tuning that may be required here. 03/29/2011 12:30:32,spid170,? ? ??,There is insufficient system memory in resource pool 'default' to run this query. 03/29/2011 12:30:32,spid170,? ? ??,??: 701<c/> ???: 17<c/> ??: 130. 03/29/2011 12:30:32,spid83,? ? ??,There is insufficient system memory in resource pool 'default' to run this query. 03/29/2011 12:30:32,spid83,? ? ??,??: 701<c/> ???: 17<c/> ??: 130. 03/29/2011 12:30:32,spid89,? ? ??,There is insufficient system memory in resource pool 'default' to run this query. 03/29/2011 12:30:32,spid89,? ? ??,??: 701<c/> ???: 17<c/> ??: 89. 03/29/2011 12:30:32,spid1s,? ? ??,Memory Pool (default) Pages <nl/>---------------------------------------- ----------<nl/> Allocations 165608<nl/> Predicted 198725<nl/> Private Target 0<nl/> Private Limit 0<nl/> Total Target 168294<nl/> Total Limit 168294<nl/> OOM Count 0 Above error shows 'Predicted' is more than 'Allocations'.. This is urgent. Please help. Thanks Ravi.