On a SQL2000 machine I have noticed that the memory settings are dynamically configured: min: 0MB, max: 2048MB. There is only 2GB on the machine and task manager and perfmon show only 80MB free. 1) How can I determine how much meory SQL Server is actually using - I tried to look in perfmon, but couldn't find the answer. 2) Also, Should I set a lower maximum memory setting so SQL Server doesn't deprive the OS of memory? As I understand SQL Server could take all the memory. 3) Overall, I want to determine if SQL Server needs 2GB or RAM or more... It looks like it is using 2GB but there aren't that many connections and I wouldn't expect perfmon to show 2GB being used... Thanks!