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.