THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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

image

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:

http://msdn.microsoft.com/en-us/library/hh204565.aspx

Follow me on Twitter @PrimeTimeDBA

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement