Control memory usage of WSUS 3.0 internal DB

1) Install the management tools for SQL Server. You need sqlncli_x64.msi (for x64 Systems) and SQLServer2005_SQLCMD_x64.msi (for x64 Systems) both o this files cane be found here

2) Run the sqlcmd utility and change the config options.

c:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE -S -E \MICROSOFT##SSE ;

If above one does not work try this

c:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE \sql\query;

1> sp_configure ‘show advanced options’, 1
2> reconfigure;
3> go
Configuration option ‘show advanced options’ changed from 0 to 1. Run the RECONFIGURE statement to install.
1> sp_configure ‘max server memory’, 512;
2> reconfigure;
3> go
Configuration option ‘max server memory (MB)’ changed from 2147483647 to 512. Run the RECONFIGURE statement to install.
1> exit

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s