Comparing DMVs between Azure SQL Database V11 and V12

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