As I mentioned in my last few posts, I have started exploring new DMVs and some enhancements to existing DMVs in SQL Server 2012 DENALI. My last few posts talked about sys.dm_exec_query_stats & sys.dm_os_volume_stats
Today, I will talk about sys.dm_os_windows_info – this DMV returns information about the operating system & version. Before I show a demo, let me clarify that this DMV is not new in SQL Server 2012 (DENALI). It is available in SQL Server 2008 R2 SP1 onwards, but not very well known.
This is the simplest of all:
You can see the following chart for windows version – http://msdn.microsoft.com/en-us/library/ms724833.aspx
6.1 means Windows 7 or Windows Server 2008 R2
You can see the following chart for the sku – http://msdn.microsoft.com/en-us/library/ms724358.aspx