August 13, 2008 at 7:46 pm
I have 13 instances (most aren't used yet but planning to) on a 64 bit XEON (8 CPU) machine with 16 GB. Presently the %Committed Bytes in Use is exceeding 80% and the PF usage is 14 GB. I have turned off all the instances except the one that are being used - 5. The avialable memory is 100%, Disk Time is 0
The target server and total server memory (for one point of time) are as follows
Target Server Memory Total Server Memory
instance1 1661216 110592
instance2 4552224 2913792
instance3 6928840 5296640
instance4 4936736 3298304
Why are these so high + committed bytes when all other indicators are low (disk and avialable memory)? Does it have something to do with minimum and maximum memory on server?
How can I go about determining if I need more memory or just a config tweak?
Over the last few hours the target memory is increasing does this mean anything
thanks
August 14, 2008 at 8:07 am
I think you are misunderstanding the Target Server Memory and Total Server Memory counters. Target Server Memory represents that Max Server Memory setting for the instance and Total Server Memory is the Memory being used by the SQL Server instance. In reality the 2 counters should be the same because SQL Server is going to grab as much memory as it can for caching data and plans. Check out this article for how SQL Server manages buffer and procedure caching.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 14, 2008 at 5:23 pm
Sorry Jack.. I don't understand because I believe the max memory is set to the default (2TBs) which that counter is not showing for any of those instances.
August 14, 2008 at 8:18 pm
BY default SQL Server install sets the MAX Memory option to 2 GB. My laptop has 1.25 GB RAM and SQL Server is set to max at 2 GB.
I can only guess that SQL Server is smart enough to throttle itself back.
THe counters you are showing show that total SQL Server Memory being used is about 12-13 GB which about the max you would want it to use as you need to leave at least 2GB for the OS.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply