SQL's use of RAM
Q: Is it normal for SQL 2005, on a 64bit system, to take 5 GB of RAM when nothing is processing?
A: Yes. SQL will grab as much memory as it can. This is normal. If you need more RAM for other apps, there’s a SQL parameter to limit the max it can allocate. As applications query SQL, it loads data to RAM to quickly respond. Once data is loaded, SQL will NOT offload the table from RAM unless it needs to. This is why, by default, SQL tends to grab as much RAM as it can. This is a by-design feature. SQL got all that RAM when processing the DataSelf BI refresh. Now that it loaded that data to RAM, it will not offload it unless you reboot the server, or configure its max RAM limit. This is how SQL works with RAM.