sqlrx logo
SQLRx Tip of the Month
 

Feb 2014
______________________________________________________________________________
SQL 2008   
SQL Server Administration: SQL 2008 - SQL 2012) Use the new dynamic management view sys.dm_os_sys_memory to view memory information from the operating system. If the System Memory State = "Available physical memory is high", this is good and indicates that the system is not experiencing external memory pressure. For more information check out

 

**HT to Glen Berry for the query: http://www.sqlskills.com/blogs/glenn/

 

SELECT total_physical_memory_kb/1024 AS [Physical Memory (MB)],

       available_physical_memory_kb/1024 AS [Available Memory (MB)],

       total_page_file_kb/1024 AS [Total Page File (MB)],

          available_page_file_kb/1024 AS [Available Page File (MB)],

          system_cache_kb/1024 AS [System Cache (MB)],

       system_memory_state_desc AS [System Memory State]

FROM sys.dm_os_sys_memory WITH (NOLOCK) OPTION (RECOMPILE)
 

______________________________________________________________________________
 
SQLRx has worked hard to minimize the impact of monitoring SQL Servers to the point that we are able to monitor high transaction systems with little impact (1% load) on the target system. Contact us today to help you monitor your SQL servers!    
As always, don't forget to regularly monitor the 11 VitalSigns  used by SQLRx to debug performance bottlenecks.

If you have a SQL question you'd like us to answer, and possibly use for the next SQLRx Tip of the Month, email it to us!  If you missed any of our previous tips, you can view them here.

For assistance or more information on optimizing your SQL Server Environment, visit us at www.sqlrx.com or email Lori Brown at [email protected].


Sincerely,

 

Lori Brown | SQLRx Senior Consultant | Integrated Services, Inc.
4144 N. Central Expwy, Suite 430  |  Dallas, TX  75204
Phone: 214.526.7680 x 113 | 800.85.SQLRx

 

 

Integrated Services, Inc.                                    
2008 winner logo small
Turning Data Into Profit

 

25 Years of Credibility & Trust

 

Join our email list          Check out our events          SQLRx Downloads