Home > Uncategorized > Windows: WSUS Windows Internal Database SQL instance taking up way too much RAM

Windows: WSUS Windows Internal Database SQL instance taking up way too much RAM

I installed WSUS 3.0 and opted to use the free SQL Server 2005 express option instead of adding it to an existing SQL DB.

I left WSUS running for a few days, during the policy test period, and while rolling out server monitoring software I noticed that RAM utilization was at 75%. Holy!

Investigation lead me to the fact that an instance of sqlservr.exe was using over 1.5GB of RAM.

The solution? To limit the amount of RAM that can be alloted to the DB, but how can this be done with SQL Server 2005 express edition?

The hard way:

It took me about two hours to find this blog post that explains the steps:

  1. Pop open taskmgr and find PID of the sqlservr.exe instance that is eating your RAM.
  2. cmd /k tasklist /svc
  3. Using the PID, identify the Database that’s causing said havoc. The default DB name of the Windows Internal Database would be MSSQL$MICROSOFT##SSEE.
  4. To adjust the max amount of RAM allocated to the database, you can use the oSQL (what I’ll call “old skool SQL“) interface or the new sqlcmd to gain access to SQL Server 2005 DBs:


    sqlcmd -E -S HOSTNAME\MICROSOFT##SSEE

    sp_configure ‘show advanced options’,1
    reconfigure with override
    go

    sp_configure ‘max server memory’,NNNN*

    reconfigure with override
    go

*where NNNN is he amount of RAM to allocate in MB

You may run into the following error upon attempted connection:


HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

To solve this, perform the following KB914277 (and enjoy the new, stylish dark blue gradient).

The easy way: Here.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: