New DMV for memory information, Really useful.

There are five new dynamic management views to present memory information:

• sys.dm_os_memory_brokers (Transact-SQL)

• sys.dm_os_memory_nodes (Transact-SQL)

• sys.dm_os_nodes (Transact-SQL)

• sys.dm_os_process_memory (Transact-SQL)

• sys.dm_os_sys_memory (Transact-SQL)

The sys.dm_os_sys_info dynamic management view has discontinued the cpu_ticks_in_ms column, and has added two new columns, sqlserver_start_time_ms_ticks and sqlserver_start_time.