February 27, 2011 at 11:26 pm
Hi all,
How can I obtain actual memory used by Sql server?
How can I calculate appropriate amount of Ram for my server?
February 28, 2011 at 9:49 am
any body can help ?
February 28, 2011 at 10:41 am
Hi,
You can use Windows Performance Monitor to see how much SQL Server uses memory. There's a counter in SQL Server: Memory Manager called Total Server Memory (KB) that shows how much your SQL Server is consuming memory currently. There's also another counter called Target Server Memory which tells you the amount of memory SQL Server wants to use.
Good indicator for having enough RAM is that your paging (Memory Object / Pages sec) should be close to 0 and you should have very high Buffer Cache Hit Ratio, also if you're Total Server Memory doesn't reach Target Server Memory, you probably have enough RAM.
As for amount of RAM needed in your server, that depends on many factors, such as database size, amount of users, etc.
February 28, 2011 at 11:01 pm
thanks for you reply,
My server has
128 GB of RAM,
Windows 2003 R2 (x64),
Sql server 2008 R2 (Data Center x64),
Min & max server memory =100,000 & 125,000.
Target server memory(kb) shows 124,870,144 (windows task manager shows the same) but Orion Network Performance Monitor shows server uses about 2Gb of ram !!! what happens here ?
Which one is true Orion Network Performance Monitor or Target server memory(Windows performance monitor)?
February 28, 2011 at 11:20 pm
Hi,
How much you see in Total Server Memory counter? That tells you the current memory consumption and Target shows how much the SQL Server will eventually try to use.
It is quite possible you're system isn't using more than 2GB at the moment, if it's still not in production. Even though you've set up min server memory as high as it is, SQL Server will not immediately use up that amount. Min server memory is basically a setting to guarantee the minimum amount of memory for your server. Once your SQL Server consumes more memory than you defined as min value, it'll not go below that amount unless you lower the min memory value.
Br,
Mika
March 1, 2011 at 1:45 am
mika.sutinen (2/28/2011)
Hi,How much you see in Total Server Memory counter? That tells you the current memory consumption and Target shows how much the SQL Server will eventually try to use.
It is quite possible you're system isn't using more than 2GB at the moment, if it's still not in production. Even though you've set up min server memory as high as it is, SQL Server will not immediately use up that amount. Min server memory is basically a setting to guarantee the minimum amount of memory for your server. Once your SQL Server consumes more memory than you defined as min value, it'll not go below that amount unless you lower the min memory value.
Br,
Mika
Total Server Memory is the same as Target server memory(kb) = 124,870,144
March 1, 2011 at 4:12 am
Hi,
For your question on which one to believe, I would go with Windows Performance Counters and Task Manager/Resource Monitor over 3rd party monitoring software. I have no experience on Orion product myself, so I can't really help with that. You could try their Support and/or Forums for advice.
Br,
Mika
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply