October 15, 2009 at 11:15 am
I have two instances running on a 64 bit box. I will try to put the question in the best possible way.Ok. I am trying to find out how much memory is required for each instance. I understand sql uses as much memory allocated. I did some research on it and most of the people suggested there is no way to findout how much is exactly required by SQL. I am looking a way to find out like if i run some tool for period of 6 hours i should be getting data which would show me that some X amount of memory is required by SQL. Please advice. Thanks,
October 15, 2009 at 3:08 pm
You need to review each instances requirements and determine how much they need based upon the utilization of that instance.
Nobody here is going to be able to tell you that, and no - there is no tool available that will magically tell you how much each instance needs.
If both instances are utilized equally, then split the memory between the two and monitor the systems. Use DBCC MEMORYSTATUS to see how much each instance is actually using over a period of time. Include major processing like month end, closing books, etc...
You should be able to identify (again, over time and monitoring usage) the peak memory utilization for each instance. Once you have that, you can then adjust each instance appropriately.
BTW - how much memory are you working with? Also, make sure you leave plenty of memory available for the OS. For example, if you have more than 16GB up to 32GB of memory - leave at least 4GB to the OS - if you have more than that, increase to 6GB or 8GB (for 64GB systems).
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
October 16, 2009 at 8:42 am
thanks Jeff. Yes i did assign more memory to OS ..before it was only 4 gb now around 8 gb and ram is 64 gb..So far things looks good.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply