SBS Monitoring and SQL not freeing up memory
Posted on 2009-04-03
It's not a major problem, but I've noticed recently, that each day, the SBS Monitoring database instance on SQL Express 2005 seems to use more and more memory and won't free it up. After about 3 days, the process is up to 1.7gb and affects the performance of the server and I have to kill the running process to free up the memory. It then begins again...
Is this to do with the daily reports generated from the SBS on performance and health? Is there anything i can do to get it to release the memory without me having to kill the process manually?