Could I allocate more memory to one database?

Posted on 2011-05-11
Last Modified: 2012-06-21
We are running Window Server 2003 Enterprise Edition with 12GB RAM. We will install SQL Server 2008 on it. We will assign 2GB to OS and 10GB of RAM to SQL Server. We have one important project will be running on the SQL Server. It would take a lot of memory. I know we could allocate memory for SQL instance. Is it possible to allocate more memory to the database of this project?
Question by:luyan
    LVL 6

    Expert Comment

    Open up SQL Server Management Studio 2008
    - Type in the information to connect to the server that has SQL server running on it and click connect.
    - Right click the server name
    - Click Properties
    - Select Memory on the left side of the window that comes up
    - Under Server Memory Options, adjust the minimum and maxiumum memory settings to what you need.

    Author Comment

    Yes, we could allocate more memory for SQL instance. Could we configure to use more memory for one database?
    LVL 13

    Accepted Solution

    You cannot allocate memory to one database. Buffer pool is shared between all databases.

    If you have enterprise edition, you can throttle CPU and query memory grants with resource governor although buffer pool and IO are shared.

    The closest thing you can do is to install another instance of SQL Server on the same box, put this database there and change memory settings per server although you have to consider overhead of running 2 instances of SQL Servers. I'd say you will lose about 1Gb of RAM with such approach but it could be worth it.  

    Author Closing Comment


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now