Thursday, October 3, 2013

SBS 2003 MSSQL$SBSMONITORING is using too much RAM

q: We are getting alerts from a server "A large amount of memory is committed to applications and processes. Consistently high memory usage can cause performance problems." Task Manager shows the MSSQL$SBSMONITORING service is using over 500MB of RAM.  We restarted it, but after a few days it climbs back up.
a: Just like with every MSSQL server, you have to set a limit to how much memory it can use, or it will use it all.

C:\Documents and Settings\Administrator>HOSTNAME
SERVER1

C:\Documents and Settings\Administrator>OSQL -E -S SERVER1\SBSMONITORING
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 0 to 1. Run the
RECONFIGURE statement to install.
1> sp_configure 'max server memory',100
2> reconfigure with override
3> go
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option 'max server memory (MB)' changed from 2147483647 to 100.
Run the RECONFIGURE statement to install.

1>