Limiting memory allocation of Windows Internal Database
Windows Internal Database is a feature used byt Windows Server to provide database capability to features such as Sharepoint, WSUS and ADFS. It is an embedded variant of Microsoft SQL Server (Wiki). You can manage the SQL server with Management Studio or by using the command line.
Open command prompt:
osql -E -S \\.\pipe\Microsoft##WID\tsql\query
Enter the following commands:
exec sp_configure ’show advanced option’, ’1’;
exec sp_configure; go
You will get a print from the server settings. To modify the memory limit to something that makes some sense type the following commands and specify the memory amount suitable for your system. I’m using 1024MB in the example:
exec sp_configure ’max server memory’, 1024;
reconfigure with override;
To quit the console type quit.