<div>
<div class="content wysiwyg-content">
I have a server running windows Server 2008 64 bit with SQL Server 2008 64 bit r2 installed. There is 32 GB RAM.<br />
I am noticing 100% memory use by SQL server. I have read plenty of articles stating that SQL server will use as much memory as is available. My question is surely MS have released a patch or process to control this usage?<br />
If I restart the SQL service, meory usage drops and it grows again over a few hours.<br />
Has anyone seen similar behaviour and if so, what can you recommend to manage this usage to keep it performing well?<br />
Thanks
</div>
</div>


I have a server running windows Server 2008 64 bit with SQL Server 2008 64 bit r2 installed. There is 32 GB RAM.
I am noticing 100% memory use by SQL server. I have read plenty of articles stating that SQL server will use as much memory as is available. My question is surely MS have released a patch or process to control this usage?
If I restart the SQL service, meory usage drops and it grows again over a few hours.
Has anyone seen similar behaviour and if so, what can you recommend to manage this usage to keep it performing well?
Thanks

SQL server 2006 Memory Performance

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.