September 19, 2007 at 6:13 am
Hi,
We have Sql server 2000 instances running on a two node cluster with 16GB of Ram on either node (/pae is enabled).
Node 1
SQLA – configured to use 4GB RAM.
SQLB - configured to use 4GB RAM.
Node 2
SQLC – Configured to use 6GB of RAM.
How do we determine how much of memory is actually used by SQLA or SQLB?
(We are planning to reduce the memory allocation to SQLA and SQLB and allocate around
8GB of RAM to SQLC)
Which are the performance counters that need to be used?
Thanks.
September 24, 2007 at 4:29 am
with awe the memory is allocated to sql server so what you're asking is how can you see memory usage? Tricky. A tool such as diagnostic manager , from Idera, will show you a graph of memory usage at the time and split it into what's using it. Use the usual perfmon counters of sysperfinfo table to actually track usage.
Page life expectancy will show how well data cache is being used - the lower the value the more pressure on the memory there is. Track the size of your proc cache to see how thta is sued - that will only grow accoording to use.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply