• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

Could I allocate more memory to one database?

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?
Thanks!
0
luyan
Asked:
luyan
  • 2
1 Solution
 
pcuniteCommented:
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.

http://aaronwball.blogspot.com/2009/06/sql-server-2008-memory-management.html
0
 
luyanAuthor Commented:
Yes, we could allocate more memory for SQL instance. Could we configure to use more memory for one database?
0
 
dwkorCommented:
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.  
0
 
luyanAuthor Commented:
Thanks!
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now