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

September 30, 2011

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

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:

Sys.dm_os_windows_info.

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?

Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.

Discover more from SQL Authority with Pinal Dave

Subscribe to get the latest posts sent to your email.

SQL DMV

SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume

SQL_VARIANT_PROPERTY: Inspect the Base Type

Ace waits at the top of dark basement stairs for ingredients, then a whole crate of lettuce arrives for a single leaf and knocks the salsa jar off the counter into Quinn's hands. Casey says, "A whole crate for one leaf? Fix the reads first."

PAGEIOLATCH Wait Stats: Waiting for Data From Disk

February 9, 2011

Kit hands the burner to Jesse, calls town hall on the wall phone, and gets stuck on hold with table 4's ticket still in Kit's pocket. In the last panel Casey holds the stopwatch up to the phone as if town hall could hear it tick: "Their clock, not ours. The wait name says who to call."

PREEMPTIVE Wait Stats: Calls Outside SQL Server

February 19, 2011

A newly lit pendant lamp illuminates an extinguished candle

When Was SQL Server Last Restarted? – Interview Question of the Week #225

May 19, 2019

8 Comments. Leave new

Raunak Jhawar
September 30, 2011 7:11 am
The DMV returns the Win OS info. The last column represents the locale information. 1033 for English.
Reply
Glen Joseph
September 30, 2011 7:12 am
probably use it to detect the OS language settings and 1033 is the operating system language (via wmi) 1033 = oslanguage us english
Reply
san
September 30, 2011 12:18 pm
SELECT *
FROM sys.dm_os_windows_info; is not working in my sqlserver why plz reply
Reply
- Binu
  September 30, 2011 12:55 pm
  Ensure you are using Denali.
  Reply
sudeepta
September 30, 2011 12:33 pm
1033 represent the “English” language setting.
Reply
- Binu
  September 30, 2011 12:54 pm
  Ensure you are using Denali
  Reply
  - Binu
    September 30, 2011 12:56 pm
    sorry, sudeepta, actually it is not intended for u. Accidentally replied
Marcos Freccia
March 26, 2012 9:07 pm
Hi Pinal,
This DMV is also available on SQL Server 2008 R2 SP1.
Regards,
Marcos Freccia
Reply

Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.