How to set memory usage of the Internal Database on a SBS 2008 By Mariette Knap internal database, memory Sometimes you need to set the maximum amount of memory the Internal Database uses on a SBS 2008 and free up memory for other applications on your server. Here is how you do that. How to determine which instance takes all that memory. OK, one step at the time. Please, remember that with Server 2008 you have x64 product that has a lot more requirements then 2003 x86. Can you do the following: Open the task manager on that server and choose processes from all users. Click Yes if the UAC pops up. Double click on the memory colomn to sort at highest memore use. Highlight the image that takes so much Ram and right click and choose Go to Service. This is one the reason Server 2008 is soooo much easier then 2003 :-) Aha! It is the Internal Database...in my case. Now I want to know about that server with the high memory usage. Which SQL instance is causing this? How to set memory usage of the Internal Database on a SBS 2008 Start Microsoft SQL Server Management Studio Express from the Start Menu In the server name box you type: \\.\pipe\mssql$microsoft##ssee\sql\query If you run into problems and see this you will need to use the build in Administrator account. That is probably disabled but you enable it from ADUC. Right click the instance you connected to and click Properties. Here you can set the maximum amount of Ram that instance will use. I would set it to 512 MB and see what happens. You will have to restart all SQL services to make the settings effective and sticky.