<div>
Here is information on managing SQL server's memory:<br />
<br />
<a href="http://technet.microsoft.com/en-us/library/ms178067.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms178067.aspx</a>
</div>


Here is information on managing SQL server's memory:

http://technet.microsoft.com/en-us/library/ms178067.aspx [http://technet.microsoft.com/en-us/library/ms178067.aspx]

<div>
<i>I'm running SQL 2008 on a 2008 R2 server and no matter how much memory I give the VM it will use 95% of it.</i><br />
SQL Server by design will use all memory that you make available to it.<br />
<br />
<i>What is the best way to determine / control the amount of memory I should give to the VM without having any performance issues.</i><br />
Give SQL Server all the memory you can afford and when that is not enough optimize your queries.
</div>


I'm running SQL 2008 on a 2008 R2 server and no matter how much memory I give the VM it will use 95% of it.
SQL Server by design will use all memory that you make available to it.

What is the best way to determine / control the amount of memory I should give to the VM without having any performance issues.
Give SQL Server all the memory you can afford and when that is not enough optimize your queries.

<div>
<div class="content wysiwyg-content">
I'm running SQL 2008 on a 2008 R2 server and no matter how much memory I give the VM it will use 95% of it. &nbsp;The server doesn't have any additional roles it fills and is dedicated to primarily SQL role.<br />
<br />
What is the best way to determine / control the amount of memory I should give to the VM without having any performance issues. &nbsp; &nbsp;It currently has 24 and I can give it more if needed but just not a database expert.<br />
<br />
Thanks ...<br />
<br />
Joel T Brown
</div>
</div>


I'm running SQL 2008 on a 2008 R2 server and no matter how much memory I give the VM it will use 95% of it.  The server doesn't have any additional roles it fills and is dedicated to primarily SQL role.

What is the best way to determine / control the amount of memory I should give to the VM without having any performance issues.    It currently has 24 and I can give it more if needed but just not a database expert.

Thanks ...

Joel T Brown

SQL Server 2008 R2 Memory Question

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.