DMV

Home/Tag: DMV

DMVs and DMFs for SQL Server – Ready Reference

Hi Friends, Last week we posted SQL Server Performance Counter Ready Reference, of which we had more than 1000 downloads instantly! We hope it was helpful for the SQL Community! You can download it from our Resource Center. Here is another wonderful piece of document that can help you find the availability of any DMV/DMF [...]

SQL Server 2014 new DMV – Figure It Out Yourself

Hi Friends, In this post, I am demonstrating how you can figure out SQL Server 2014 new DMV, yourself! From SQL Server 2014 VM (or a physical box), add a Linked Server connection to a SQL Server 2012 VM (or a physical box) And execute the following script: SELECT a.NAME sql2014 ,b.NAME FROM sys.sysobjects a [...]