CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services

AlwaysON - HADRON Learning Series - New DMVs

AlwaysON - HADRON Learning Series - New DMVs

Rate This
  • Comments 4


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

Leave a Comment
  • Please add 7 and 8 and type the answer here:
  • Post
  • Thanks BOB

  • 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  

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

  • RDORR

    I am not sure about the new LOGINFO output.

Page 1 of 1 (4 items)