MSSQL occupying memory
Posted on 2002-03-26
I have a MSSQL7.0(sp3) installed in a Windows2000 server(sp2, 1GB RAM, Dual-processor PIII 700 Xeon). It is installed as default and there isn't fine tunig done. I realize that the MSSSQL Server process is occupying nearly 850MB of the RAM (from Task Manager), even though all application has been shut down and no one is accessing it, it looks like it is not releasing the memory.
And sometimes, there are blocking proccesses in the SQL and need to kill it else the application will hang up.
Why ? Is this related ?