Home Microsoft Windows Server 2008 and Server 2008 R2
WSUS Windows Internal Database Max Memory Size Print E-mail

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


< Prev   Next >
 

vcplogo 

    

 

DISCLAIMER: All advice, tips, guides and other information on this website is provided as-is with no warranty or guarantee. While most information is correct to the best of my knowledge, I am not reponsible for any issues that may arise in using the information, and you do so at your own risk. As always before doing anything; check, double check, test and always make a backup.

 

Popular

Help VMadmin

All resources on this site are provided absolutley free. However it takes time and money to keep the site running. If any information has been helpful to you or your company, and you wish to make a donation to help keep VMadmin.co.uk running you can do so via paypal, and it would be much appreciated.

Click to donate to VMadmin.co.uk via paypal.