SQL Server Performance Forum – Threads Archive
min/max memory setting multiple instances
I have a cluster with 15 instances. None have had the min/max memory set. Should it? I was watching the memory usage and saw where one very active instance had grabbed nearly a quarter of all the available ram. Thanks…JC IIIWhat is the availble physicial memory on this server?
What is the operating system? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
There is 4gb RAM and 2 processors. THe OS is Win 2003 server SP1. THanks
]]>