sys.dm_os_windows_info

A minor DMV with SQL Server this particular one doesn’t really provide much information about the OS other than the version and service pack level. It is nowhere near the amount of information that could be captured using other means. You can’t even say which edition of the OS its running so I really don’t see any DBA using this DMV other than to casually check the OS verison.

Click here for the msdn article on this DMV

SELECT *
FROM sys.dm_os_windows_info

The only real useful information provided in this DMV could be the local info which most people are usually not sure about. If you find an interesting use for this DMV please post a comment with the way you’re using it.