May 7, 2009 at 11:42 am
I am on a SQL 2005 Enterprise SQL Server with two instances on the same box.
The Min and Max are the defaults of 0 and 214748347,
the lock in memory pages has not been set.
Only 16 GIG RAM available.
I thinking change MAX to 6 GIG and MIN to 1024.
Is that a fair statement for the MIN Memory.
What is happening is the availabe Mybtes fluncates at large amounts and currently at 83396 k 81 MB ,,total 16771724
Limit is 41303172 (k)
May 7, 2009 at 1:36 pm
The min setting here is less important than the max setting. Without setting the max memory - both instances are trying to use memory that the other instance is using, causing the OS to swap memory between the two.
Whether or not both instances need 6GB each, or one instance only needs 2GB and the other needs 10GB is something we can't tell you. You need to figure out what each instance requires. But, you really do need to set the maximums for each instance so that you are not exceeding 12-14GB.
I would be more inclined to leave 4GB of available memory to the O/S to manage, leaving only 12GB to allocate between the instances.
Once you have that figured out, you can set lock pages in memory unless you have other processes running (e.g. SSIS, SSRS, etc...)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 7, 2009 at 4:47 pm
Thanks that what i thought was happening with the OS swapping out. I set the MAX and then only do the windows lock in memory if other processes are run on the SQL Server.
Cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply