January 15, 2008 at 1:28 pm
We have an x86 sql 2000 server with 4GB of RAM, a quadcore Xeon, a RAID 5 drive C, and its utilization is generally low. Typical perfmon counters: CPU < 5%; available Mbytes, 1800; typical disk time 5-10 %; Committed bytes in use < 25%, pages\sec near 0.0.
For various reasons I need to install a sql 2005 instance on the same box and both instances will be up and running at the same time.
How, using Perfmon (?), can I determine the max amount of memory to assign to each instance? (It is my understanding that I definitiely need to limit the amount of RAM used by each instance.)
TIA,
Barkingdog
January 15, 2008 at 2:58 pm
Set the maximum memory amount in both instances to something other than "all memory".
Otherwise both instances will be trying to take over all of the memory.
You don't want to be paging. So, for starters, set each instance to max of 1.5GB each. That leaves 1GB for the OS and all of those other applications that you may have running on the server. If after a while, you still find that you have unused real memory, then push the limits up for both instances.
January 15, 2008 at 4:04 pm
as long as you haven't enabled awe/pae or 3gb switch each instance will be limited to the 2gb address space. I'd suggest you allocate no more than 1Gb to each instance as max memory setting, there's a lot of stuff which runs out of process in sql 2005 e.g. SSIS SSRS etc.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 18, 2008 at 9:35 am
I would enable /3GB switch and limit both sql instances to 1GB initially. You may be able to tweak them up a bit but wouldn't expect much.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply