Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
eron19
Starting Member
2 Posts |
Posted - 2004-09-21 : 05:51:31
|
im wondering.... if there is a way to find out why sql server is using so much memory. in the task manager it says its using 500k or so. i believe this is usual...but the server has been sitting there doing nothing for a few days. so...why so much? and how can i find out what database is using so much?excuse me if this is a crazy question... but im new :)thx in adve |
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-21 : 07:24:50
|
SQL Server doesn't really ever "give back" memory once it claims it. It goes up to the maximum allowed and sits there. Normally, this is a good thing since it's usually on it's own server. It can then best manage the memory it has for processes. If you have SQL Server on a server with other applications, you would normally limit the memory it can use so everything else doesn't grind to a halt.Databases don't use memory, processes do. So, your second question really doesn't have an answer.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|