Posts Tagged ‘SQL Server’

MSSQL$SBSMONITORING service consumes excessive memory.

April 23rd, 2008


MSSQL$SBSMONITORING service consumes excessive memory causing performance degradation or a large number of emails notifying of excessive memory usage.


sqlservr.exe excessive memory usage, MSSQL$SBSMONITORING excessive memory, MSSQL$SBSMONITORING memory leak , SBS MSSQL$SBSMONITORING memory leak


Microsoft Small Business Server 2003 SP2


After the small business server runs for a period of time one of the sqlservr.exe processes starts consuming excessive memory up to 1,500,000 K (1.5GB). The daily reports that SBS sends, has an allocated memory error with the following text:

A large amount of memory is committed to applications and processes. Consistently high memory usage can cause performance problems.

To determine which processes and applications are using the most memory, use Task Manager. Monitor the activity of these resources over a few days. If they continue to use a high level of memory and are less critical processes or services, try stopping and then restarting them.

You can disable this alert or change its threshold by using the Change Alert Notifications task in the Server Management Monitoring and Reporting taskpad.


There is not really a true fix for this. The following MS KB Article explains the theory behind how SQL allocates memory. this article doesn’t have the informaiton to actually change the memory thresholds. For most SBSs you should not need a large amount of memory dedicated to the monitoring service. Because of this it would be acceptable to set some thresholds for that service. I found a few pages that pointed to the following code to set the memory min and max.

**Note if you have a high traffic server you will want to research what allocations to make for this service. I set mine to a minimum of 0 and max of 512. The following code does set the memory allocation in MB.

Taken from:

Open a command prompt and enter the following (The switches are Case Sensitive):
osql -E -S sbsserver\

You will enter the osql command prompt. Run the commends below (replace
with the amount of memory):

EXEC sp_configure ‘show advanced options’, 1

EXEC sp_configure ‘min server memory’,

EXEC sp_configure ‘max server memory’,

After doing the above steps, you may run the commands to check the
configured memory usage:

EXEC sp_configure

Tags: , , ,
Posted in Uncategorized | Comments (0)