If I have a SQL server process that has been running for some time, are there any methods to determining how much memory it really needs to run? I have a couple of low usage databases and I want ...

Server:DL380 G5 dual dual core 2.33Ghz, 4GB RAMWin2K3 Std R2 SP1 x64SQL 2005 Std SP2 x64This weekend the SQL box chewed through every last bit of memory available. I came in this morning finding ...