Partilhar via

AlwaysON - HADRON Learning Series - New DMVs

  • Artigo

As I have been reviewing and learning about HADRON I have found a great wealth of information exposed in the DMVs.  I have pulled together a starting, entity relationship diagram and the HADRON PMs have been helping me refine it.  We continue to update it for changes but I thought you would find it helpful as well as you start to use HADRON.

WARNING:   The series is based on pre-release software so things could change but I will attempt to provide you with the best information I can! 

image

Bob Dorr - Principal SQL Server Escalation Engineer

Comments

  • Anonymous
    December 14, 2010
    Thanks BOB

  • Anonymous
    December 19, 2010
    Hi, Nice article. You can discover a lot more about DMVs in this forthcoming book www.manning.com/stirk. Chapter 1 can be downloaded for free and includes scripts for: A simple monitor Finding your slowest queries Find your missing indexes Identifying what SQL is running now Quickly find a cached plan Thanks Ian  

  • Anonymous
    January 14, 2011
    Thanks Bob. Do you know if HADRON is also responsible for the new column - "RecoveryUnitID" in DBCC LOGINFO in Denali?

  • Anonymous
    June 01, 2011
    RDORR I am not sure about the new LOGINFO output.

  • Anonymous
    January 07, 2015
    simply wonderful depiction !!! Thank you !

  • Anonymous
    January 07, 2015
    I bought Mr. Stirk's book on DMV,, very much worth the money spent.