• Ron,

    Thanks for taking the time to write an article using a real world example of why DMVs can be much more powerful than their Performance Monitor counterpart.

    Would you say that best use case of DMVs over performance monitor & SQL Profiler would be that the recorded data can be better used as a central repository for various SQL instances (like in your 50 geographical location) case?

    I typically use just performance monitor to do these things, and I'm not too sure of the best use cases for using DMVs over them, other than preference.

    Lastly, the counters you provided, do you recommend to monitor these 24x7 or just in re-active cases or scheduled pro-active cases (e.g., on the 1st day of every month for 24 hours).