July 24, 2003 at 8:18 am
We have two seperate sql2k services and both appear to be grabbing whatever memory is available, thus Windows RAM is always running at close to 100%. Does this sound correct and if so is it best to leave well alone or tailor each service to use a maximum amount of memory ?
July 24, 2003 at 8:41 am
SQL Server is designed to take as much as available memory and relaese the memory Once the amount of memory reaches the point where only 4 MB to 10 MB is free and other processes need memory.
See BOL "Dynamically Managing Memory Between Multiple Instances"
Monitor performance counter SQL Server: Buffer Manager: Buffer Cache Hit Ratio for your instances. If it is lower than 90% consistantly, I would reconfigure more memory to the instance.
July 24, 2003 at 1:31 pm
With multiple instances, you will likely run into issues if both instances are being used regularly. I'look at the usage and tweak it between them, but definitely set them both to some range.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply