Tag Archives for " Tip of the Month "

Feb 03

New Dynamic Management View

By SQLRx Admin | SQL Server

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 http://technet.microsoft.com/en-us/library/bb510493.aspx **HT […]

Continue reading