The default max memory size for the Windows Internal Database (used by WSUS) is unlimited, so all memory available to the operating system. You may wish to change this to relinquish some memory to other processes if sqlservr.exe is using too much memory.

1. Open a SQL command prompt.

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E


2. Execute the following SQL modifying the memory to your needs.
sp_configure ’show advanced options’, 1;
reconfigure;
go
sp_configure ‘max server memory’, 512;
reconfigure;
go
exit


Share this blog post on social media:

Social Links

Disclaimer

All advice, installation/configuration how to guides, troubleshooting and other information on this website are provided as-is with no warranty or guarantee. Whilst the information provided is correct to the best of my knowledge, I am not reponsible for any issues that may arise using this information, and you do so at your own risk. As always before performing anything; check, double check, test and always ensure you have a backup.

Copyright ©2016 Andy Barnes - Please do not copy any content including images without prior consent!

Designed and Hosted by Andy Barnes