Get Operating System Memory Statistics in SQL Server


To totally unlock this section you need to Log-in


Login

Often Database Administrators would like to check memory usage on operating system level. Of course they can use many tools that works on operating system level. However Sql Server 2008 introduced the new dynamic management view sys.dm_os_sys_memory that enables DBA to use simple query to get those statistics.

The dynamic management view sys.dm_os_sys_memory returns returns a complete picture of memory on operating system level, including information about total and available physical memory, total and available page memory, system cache, kernel space and others.


To totally unlock this section you need to Log-in


Login

1 thought on “Get Operating System Memory Statistics in SQL Server”

Comments are closed.