In the continuing series of "things I notice in SQL Server which I didn't know were there", I noticed the very simple but very useful sys.dm_os_sys_memory earlier this week. Why do I like this? Well obviously you can extract the memory information exposed
