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';
exec sp_configure 'max server memory', 2048;
reconfigure with override;