SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System

One more quick introduction to DMV for Denali. Following DMV provides information about Windows Operating System. Here is the quick example of the same.

This DMV returns information about the operating system volume (directory) on which the specified databases and files are stored. Here is the quick example I have created for the same.

SELECT *
FROM sys.dm_os_windows_info;

Here is the screenshot of the same:

SQL SERVER - Denali - DMV - sys.dm_os_windows_info - Information about Operating System denalidmv

Here is my question back to you – where would you use this stored procedure in your application? What is your preferred method to know details about Windows? One last question – what is 1033 in the last column of the table result and what is 1033 represent?

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL DMV
Previous Post
SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume
Next Post
SQL SERVER – CE – Samples Database for SQL CE 4.0

Related Posts

8 Comments. Leave new

Leave a Reply