THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tamarick Hill

July, the 31 Days of SQL Server DMO’s – Day 13 (sys.dm_os_windows_info)


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

Published Saturday, July 13, 2013 10:15 AM by Tamarick Hill


No Comments
New Comments to this post are disabled
Privacy Statement