Dear All,

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 –

6.1 means Windows 7 or Windows Server 2008 R2

You can see the following chart for the sku –



Rahul Sharma

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook