Category Archives: Tweak

Stop the SBS 2008 Console from starting automatically

The SBS 2008 console is useful when setting up a server – but it starts up every time you log in! Whilst this is beneficial for a client administrative user (being presented with the easiest way to do common tasks), as a systems integrator regularly logging in to a system, you will find that you don’t need this console most times! We also give line-of-business application vendors their own administrative account, and they generally don’t need the SBS console – just log in, troubleshoot or upgrade their app, and manage a SQL database.

It is quite easy to disable, just a bit counter-intuitive as to the location. It’s not in startup, not in the registry run keys – but a scheduled task!

  1. Go to Start -> Administrative Tools -> Task Scheduler
  2. In the left-hand pane, expand out to Task Scheduler Library -> Microsoft -> Windows -> Windows Small Business Server 2008
  3. Right-click on the ‘Console’ scheduled task and select ‘disable’
  4. Log off and log back on to test!

Thanks to the Screencast on

SQLSERVR.exe using lots of memory

On a Windows Small Business Server 2003 server (RTM, SP1, SP2, R2) you may find that alot of memory is used straight out of the box.

On a few of my client sites, I have seen this happening recently, causing some performance issues for LOB applications. If have found SQLSERVR processes to be the culprit at both of these sites, with some instances using up to 500mb.

SBS uses instances of MSDE for a few of its core tasks:

  • WSUS (For centrally managing and reporting on the Windows Update process to Small Business Clients)
  • MSFW (For the ISA Server 2000 / 2004 instance shipped with SBS Premium)
  • SBSMONITORING (For the inbuilt performance and usage reporting)

None of these instances require so much memory! I have no problem with a SQL / MSDE instance using memory when it is for a LOB application, but for maintenance, reporting, and logging?!

To limit the amount of memory each instance can use:

  1. Determine which instances you wish to limit. I do this by finding the process ID using the built in Task Manager, then determining what instance is running under that process ID with Sysinternals Process Explorer.
  2. Launch a command prompt
  3. Start the SQL prompt, connecting to the desired instance (e.g. SBSMONITORING)
  4. Execute the following commands to enable setting of advance options:
    USE master
    EXEC sp_configure 'show advanced options',1
  5. Execute the following commands to set the maximum memory in MB. Replace 100 with your desired setting (I use 100MB):
    USE master
    EXEC sp_configure 'max server memory (MB)',100
  6. Execute the following commands to disable advanced settings, for safety’s sake:
    USE master
    EXEC sp_configure 'show advanced options',0
  7. quit

Within about 30 seconds the instance should have dropped it’s memory usage to within about 50mb of your desired setting. Changing this actually changes the size of the dataset that is cached in to memory, there is still other overhead that means your active memory usage may still be around 175mb.

Thanks to Tokahao’s post at the WSUS Forums for this info.