The sys.dm_os_windows_info DMV is probably the most simplistic DMV that I will show you during this whole 31 days of DMV’s series. Generally I would not post something this short but lets be honest, it’s the weekend and I’m sure you all have better things to do than sit around and read my blog! :)
So with that being said, lets get into this. The sys.dm_os_windows_info DMV provides you basic information about the version of Windows that you SQL Server instance is currently running on. Lets run this query so we can see the results returned.
SELECT * FROM sys.dm_os_windows_info
As you can see, only 4 columns are returned from this DMV. The columns are self-explanatory for the most part but just so we can say we went through them, the first column, ‘windows_release’, represents the Windows Operating System version number. Then second column ‘windows_service_pack_level’ is the current Windows Service Pack level that is installed on the server. The third column is the windows sku number and the fourth column is the identifier for the language of the operating system.
This is a very basic DMV to return Operating System information.
For more information on this DMV, see the below Books Online link:
Follow me on Twitter @PrimeTimeDBA