December 4, 2008 at 9:48 pm
Hello!
We have just configured SQL Server 2005 64-bit two node active/passive cluster with 32 GB of RAM. I have limited SQL Server memory usage to 26 GB. Total Server Memory (KB) shows value 16MB at the moment. Target Server Memory (KB) is showing 27262976 (26 GB).
I am wondering if such low value of Total Server Memory is expected since SQL Server just started and there is not much going on. I would expect this value to increase over time.
Any comments are greatly appreciated.
Thanks,
Igor
December 4, 2008 at 10:04 pm
Yes , client connection increase, maintainence jobs run and data grows you would see increase in memory usage.
It is normal since you have just started it.
Cheer Satish 🙂
December 5, 2008 at 12:46 am
a warm server should show very different memory usage
if you've only just started it, monitor for a week or so
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2008 at 3:19 am
I run a similar A/P cluster, running 64-bit Enterprise.
Each node has 64GB of memory. At pressent the active node is using 14GB of memory (even though it has been capped at 58GB) and the passive node is running at 1.18GB for the entire server inc O/S.
We are poc'ing sharepoint at the moment and when its being tested the memory usage on the active server goes up and comes back down when usage slackens off.
Of course we have 32-cores per node, of which each core has 8MB onbaurd cache so its never busy for long 😉
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 5, 2008 at 11:17 am
Thanks everybody for their comments!
Igor
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply