Share via

Comparing DMVs between Azure SQL Database V11 and V12

  • Article

As we know, the Azure SQL Database V12 had a huge improvement in terms of features available. Per consequence, more DMVs were enabled.

You can check it out what's new in SQL Database V12 in the following link:

https://azure.microsoft.com/en-us/documentation/articles/sql-database-v12-whats-new/

 

In V12, there are: 117 new DMVs, 28 were kept and 4 were removed.

It's important to say that some DMVs will not return rows, because the feature related to them is not enabled yet.

 

Also, I'm sharing with you one way to compare V11 with V12, see sample below and PDF attached for more details.

 

 

MSAzureSQLDB_DMV_VersionComparison.pdf

Comments

  • Anonymous
    May 13, 2015
    Hi Alex. Great post. Thanks for sharing all your knowledge with us. Regards.