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.
| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-02-23 : 08:41:06
|
| Hi Experts,I am facing this problem in one of my server which is 2008 sp1. i got this error message when im tryong to connect to one of the instance in the same server."There is insufficient system memory in resource pool 'internal' to run this query"but when im trying to connect to the other instance its getting connected. as its a production server please let me know what i need to do so that this problem should be taken care...Thank you in Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-23 : 17:08:53
|
| Thank you Kizer for the solution but How do i configure the instance to use more memory please let me know about this. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-02-23 : 17:55:57
|
| It's in sp_configure or right click the server and go to properties. If you've got more than one instance on a server, each should be configured with a max value and perhaps even a min value. The max is important so that it doesn't start the other instance or the OS.For instance, I have a 48GB system with two instance. We give 8GB to the OS, and then each instance is configured for 20GB for max memory.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-24 : 08:12:08
|
| ok thank you very much Kizer for the valuable information. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
There is insufficient system memory