<div>
does this helps somehow?<br />
<br />
<a href="http://www.projectenvision.com/blog/Sql-Server-Get-Operating-System-Memory-Statistics" rel="ugc">http://www.projectenvision.com/blog/Sql-Server-Get-Operating-System-Memory-Statistics</a><br />
<a href="http://www.dba-oracle.com/t_sql_server_ram_buffer_cache_scripts.htm" rel="ugc">http://www.dba-oracle.com/t_sql_server_ram_buffer_cache_scripts.htm</a><br />
<a href="http://msdn.microsoft.com/en-us/library/ms190924.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms190924.aspx</a><br />

</div>


does this helps somehow?

http://www.projectenvision.com/blog/Sql-Server-Get-Operating-System-Memory-Statistics [http://www.projectenvision.com/blog/Sql-Server-Get-Operating-System-Memory-Statistics]
http://www.dba-oracle.com/t_sql_server_ram_buffer_cache_scripts.htm [http://www.dba-oracle.com/t_sql_server_ram_buffer_cache_scripts.htm]
http://msdn.microsoft.com/en-us/library/ms190924.aspx [http://msdn.microsoft.com/en-us/library/ms190924.aspx]


<div>
do you mean it reaches the 28GB max that you set? &nbsp;I don't think that is abnormal, SQL server is designed to grab memory like that and release it back very quickly if other apps require it.
</div>


do you mean it reaches the 28GB max that you set?  I don't think that is abnormal, SQL server is designed to grab memory like that and release it back very quickly if other apps require it.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have sql server 2008 R2 which was installed on windows 2008 R2 box and it consists of 32 GB of Ram and we allocated 28GB to sqlserver with min and max server setting.some times memory is pegging to 100%.i would like to know the sql server utilization alone &nbsp;at any point of time &nbsp;without using perfmon and task manger.do we have any qurey(DMV/DMF) to identify this?<br />
<br />
Thanks in advance
</div>
</div>


Hi,

I have sql server 2008 R2 which was installed on windows 2008 R2 box and it consists of 32 GB of Ram and we allocated 28GB to sqlserver with min and max server setting.some times memory is pegging to 100%.i would like to know the sql server utilization alone  at any point of time  without using perfmon and task manger.do we have any qurey(DMV/DMF) to identify this?

Thanks in advance

sql server 2008 memory issue

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.