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;

Windows Store Error – Firewall

Hi everyone

Today I wanted to share a tip for any sysadmin can encounter. It’s for the Windows Store app and the GPO.

I stumbled into a environment that blocked the Windows Store to work, after multiple test I found that you really need the Windows Firewall at On to be able to restore the Windows Store.

The culprit in my case was a GPO that set at Disabled that settings;

It took me time to figure it as the machine was using a third party firewall’s solution, so the computer was not alerting me at all that the firewall was missing, and the store app just refused to open without any error.