Limit SQL Server maximum memory SQL of WSUS

  • Start SQL Server Management Studio
  • Connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
  • Start a “New Query”
  • And then put this into you SQLQuery1.sql window

sp_configure ‘show advanced options’,1
reconfigure with override
sp_configure ‘max server memory’, 256
reconfigure with override

  • Then push the execute buttom, this will limit you SQL of WSUS to 256MB, whitch should be enough.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *