SQL DMV Archives - Page 20 of 24 - SQL Authority with Pinal Dave

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

September 30, 2011

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

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…

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

September 30, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL DMV

SQL Server Denali has many new interesting feature – one of the interesting feature is New DMVs. 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 DB_NAME(f.database_id) DatabaseName,…

SQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns

September 28, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts

SQL Server version next Denali has lots of enhancements. Some of the enhancements are just game changing and overcomes needs of more coding to do the same thing. Similar function DMV is sys.dm_exec_query_stats. There are four new columns added to this DMV. I have often used this DMV to check…

SQL SERVER – Author’s Book is Available in India and USA

August 25, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Joes 2 Pros, SQL DMV, SQL Scripts, SQLAuthority Book Review

I am feeling very good to write this short blog post. My book is now officially available on in India and USA. In India you can get it from Flipkart – In USA you can get it from Amazon – This book is just like this blog and contains all…

SQL SERVER – Find Details for Statistics of Whole Database – DMV – T-SQL Script

June 29, 2011

Pinal Dave

SQL Performance

SQL DMV, SQL Scripts, SQL Server, SQL Statistics

I was recently asked is there a single script which can provide all the necessary details about statistics for any database. This question made me write following script. I was initially planning to use sp_helpstats command, but I remembered that this is marked to be deprecated in future.

SQL SERVER – Pending IO request in SQL Server – DMV

March 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV

I received following question: “How do we know how many pending IO requests are there for database files (.mdf, .ldf) individually?” Very interesting question and indeed answer is very interesting as well. Here is the quick script which I use to find the same. It has to be run in…

SQL SERVER – CXPACKET – Parallelism – Advanced Solution – Wait Type – Day 7 of 28

February 7, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts, SQL Wait Stats

Earlier we discussed about the what is the common solution to solve the issue with CXPACKET wait time. Today I am going to talk about few of the other suggestions which can help to reduce the CXPACKET wait. If you are going to suggest that I should focus on MAXDOP…