September 12, 2003 at 8:37 am
I have a SQL server running with 3.5 GB of memory and two instances. The two sqlserver.exe use about 1.7 GB & 500 MB
(it is not configured with 3 GB switch yet). I see that the cache hit ratio is about 70% for the sql instance using 1.7 GB.
Even when I stop the instance using 500 MB, hit ratio does not change. There is 1.1 GB of available memory.
My concern is why does the SQL not take the rest of the memory (upto the 2 GB max without the 3 gb swicth) to improve the cache hit ratio.
Also, if I configure with 3 GB switch, then can I still leave the sql dynamic config. Since I have 2 SQLs , I would like
them to negotiate how much each wants. Since some times one of them is busy and other times the other one, I cannot
allocate fixed memory for each.
thanks
September 12, 2003 at 9:08 am
Only 2GB can be used by applications (Non-system processes) if 3GB is not enabled. After you stop another instance, you may have to wait for sometime before you see the memory consumption changes in the active instance.
quote:
Also, if I configure with 3 GB switch, then can I still leave the sql dynamic config. Since I have 2 SQLs , I would likethem to negotiate how much each wants. Since some times one of them is busy and other times the other one, I cannot
allocate fixed memory for each.
I think you do the right configuration in this case. /3GB just extends your applications to use more memory which was reserved for system processes if it is not enabled.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply