<div>
Open up SQL Server Management Studio 2008<br />
- Type in the information to connect to the server that has SQL server running on it and click connect.<br />
- Right click the server name<br />
- Click Properties<br />
- Select Memory on the left side of the window that comes up<br />
- Under Server Memory Options, adjust the minimum and maxiumum memory settings to what you need.<br />
<br />
<a href="http://aaronwball.blogspot.com/2009/06/sql-server-2008-memory-management.html" rel="ugc">http://aaronwball.blogspot.com/2009/06/sql-server-2008-memory-management.html</a>
</div>


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 [http://aaronwball.blogspot.com/2009/06/sql-server-2008-memory-management.html]

<div>
Yes, we could allocate more memory for SQL instance. Could we configure to use more memory for one database?
</div>


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

<div>
<div class="content wysiwyg-content">
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?<br />
Thanks!
</div>
</div>


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!

Could I allocate more memory to one database?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.