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.
Share this:
Share this page via Email Share this page via Stumble Upon Share this page via Digg this Share this page via Facebook Share this page via Twitter

You may also like...

Leave a Reply

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