I am running an SBS 2003 R2 server with Xeon 3050 and 2GB RAM. The system was obtained from Dell a few months back and SBS was already installed out-of-the-box.
I am using SBS monitoring and have consistently received high memory allocation warnings from the outset. I came across this article: http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx
and was able to identify MSSQL$MICROSOFT##SSEE as the main culprit with about 415MB RAM usage. However, the procedure to control the SQL processes does not appear to work for MSSQL$MICROSOFT##SSEE, which I understand is an embedded SQL server.
Why is this process running and why is it taking up so much memory? Can it be limited?