Friday, September 07, 2007

SQL Allocated Memory Alert Fix (From a Diva)

I typically like to keep my content on my site unique, but every once in a while, you get enough questions about a particular topic that's posted somewhere else, and you think "Dang! I wish I had that blog post here". Well, That's what I'm doing.

One of our MVPs, Susan Bradley, has an outstanding post on how to deal with SQL allocated memory alerts from SBS 2003.

That post is available here.

Susan's post gives step-by-step instructions for how to correct the MSSQL$SBSMONITORING service when it starts using too much memory, and your server starts sending you these:

Allocated Memory Alert on DOMAIN

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.

So if you're seeing this error, head on over to Susan's site, and get it resolved!

Thanks for a great post Susan!

In affiliate marketing, one can always save on cheap hosting in order to invest more on marketing. However, the domain name is not everything. The host should be compatible with the wireless internet service and should come with online backup free of charge.