Tutorials

Specify Alternate Text

How to set memory usage of the Internal Database on a SBS 2008

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:

  1. Open the task manager on that server and choose processes from all users. Click Yes if the UAC pops up.
    How to set memory usage of the Internal Database on a SBS 2008
  2. Double click on the memory colomn to sort at highest memore use.
    How to set memory usage of the Internal Database on a SBS 2008
  3. 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 :-)
    How to set memory usage of the Internal Database on a SBS 2008
  4. 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
How to set memory usage of the Internal Database on a SBS 2008
  1. Start Microsoft SQL Server Management Studio Express from the Start Menu
    How to set memory usage of the Internal Database on a SBS 2008
    In the server name box you type:
     
    \\.\pipe\mssql$microsoft##ssee\sql\query
  2. 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.
    How to set memory usage of the Internal Database on a SBS 2008
  3. Right click the instance you connected to and click Properties.
    How to set memory usage of the Internal Database on a SBS 2008
  4. 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.
    How to set memory usage of the Internal Database on a SBS 2008

About www.server-essentials.com 

www.server-essentials.com is founded by Mariette Knap, a Dutch Microsoft MVP. www.server-essentials.com is a community for IT Consultants and Business Owners who, themselves, take care of the IT infrastructure and Employees who do that little extra in the company to keep things running. Our forum is for discussing all things ‘IT’ and more.  Our documentation is top notch and written by and for the community.

Change your cookie settings


 
Contact Us

Concentrix BV

C. de Rijcklaan 1

3723 PM Bilthoven

The Netherlands

KvK 30202318

VAT Id 814036739B01

The layout of this page is made to be viewed online.