I'm wondering why memory management even, in the newest versions of MS SQL Server (e.g SQL Server 2000), seems to be working very poorly.
I'm facing problems with memory usage in a 5-10 user environment (3-4 simultaneous users).
An VS.NET based application (iScala) is being used during working hours, and the memory usage of SQL Server processes is continously 1000 - 1250 meg (or more) even if users logoff form the system. The total amount of RAM is 2 GB on this server. The op.sys version in this case is SBS Server 2003.
The problem is that the SQL Server is not releasing the memory until a total re-boot of the server.
Is there a general approach to this problem ? I don't believe that the iScala application design would be main reason this memory problem.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!