July 12, 2011 at 1:29 am
Morning all.
Can someone confirm if I have this correct ?
I want to allocate a specific amount of available memory to 1 SQL instance.
SQL 2005 64 bit
6 instances on the server.
Server recently upgraded to 8 Gb of ram.
I want to allocate 4 gb of that to 1 instance.
Do I set the minimum server memory to 4000 (mb)
and leave the maximum to 6000 (Mb) or default setting , leaving 1 gb for the OS and other instances ?
Many thanks for any advice.
MD
July 12, 2011 at 9:19 am
Are you sure you want to do that?
Most of the time it's better to let SQL handle memory allocations.
July 12, 2011 at 9:25 am
not entirely sure.
Want to understand how to allocate the extra memory to 1 instance.
July 13, 2011 at 8:38 am
MickyD (7/12/2011)
Morning all.Can someone confirm if I have this correct ?
I want to allocate a specific amount of available memory to 1 SQL instance.
SQL 2005 64 bit
6 instances on the server.
Server recently upgraded to 8 Gb of ram.
I want to allocate 4 gb of that to 1 instance.
Do I set the minimum server memory to 4000 (mb)
and leave the maximum to 6000 (Mb) or default setting , leaving 1 gb for the OS and other instances ?
Many thanks for any advice.
MD
1) why so many instances? you are gonna suffer SIGNIFICANT memory pressure issues with just 8GB of RAM because each instance takes up 'overhead' RAM. Not good.
2) you could set 1 instance to get more than the others. Pick whatever numbers you feel appropriate. It isn't gonna matter much because the server is gonna suck no matter what settings you have. :hehe:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 9:17 am
Performance could be less than expected, 8GB isn't a lot of memory for a SQL Server.
SQL Server uses ~512MB of OS memory is for each SQL instance on a typical day. That number varies, and I actually have an article I just submitted on this topic, but let's just go with 512 for now.
For your proposed configuration you're looking at 3gb of memory just running sql, that leaves you with 5 GB for the buffer pool on 6 instances.
it's possible if you're just doing dev, but there is probably a better way to use your resources.
You would be better off consolidating databases onto a single instance if that's possible.
check this guide by MVP Hilary Cotter
~C
Craig Outcalt
July 13, 2011 at 9:19 am
Thanks for up dates everyone.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply