Limit WSUS memory usage with HeidiSQL

Hi everyone

Today I wanted to share a tip if your WSUS database (SQL) is eating too much resource on your server.

Like shown there;

or there too;

There is multiple way to do it, but I wanted to share a simple way to do it without any native SQL tool installed. For that reason I used HeidiSQL portable edition.

After it’s open, you need to select a named pipe;

Click to use windows authentication, and in the database path please put;

\\.\pipe\Microsoft##WID\tsql\query (Windows Server 2012 +)
or 
\\.\pipe\mssql$microsoft##ssee\sql\query (pre 2012)

It would look that way;

After that you it the Request tab, and you enter;

You can check the configuration;

After you issue the last command to set the memory you want it to use;

In my example I used 512, but I recommend 1024+ in the minimum.

To resume, it would be those command we used;

exec sp_configure 'show advanced option', '1';

reconfigure;

exec sp_configure;

exec sp_configure 'max server memory', 2048;

reconfigure with override;

Advertisement