Post reply

Good books for DMVs

  • July 1, 2011 at 2:18 am

    #240705

    Gurus,

    I know BOL is the best unbeaten asses for MSSQL concepts. Inspite of that, i want to understand all the dmvs and their relationship with the other dmvs..

    My problem is that even if I know a DMV by name, if i dont understand what are the column definition very precisely, I cant use that dmv in my real life. specially, my knowledge is in not useful while produciton isses.

    I want to have a good bookish knowledge of dmvs based on the area. (databases, server wide maintenance, database mirroring, etc) I downloaded the ER diagram of the DMVs. but, it is a maze... so please any kind hearted person out there.. please suggest be good books for understading dmvs very precisely..

    SQL 2008 R2 suggestions are highly appreciated.

    Thanks in advance.

    Jagan kondapalli

    Thanks
    Jagan K

  • July 1, 2011 at 2:50 am

    #1346913

    sql server 2008internals text book has a large (ish) section on DMVs.

  • July 1, 2011 at 2:57 am

    #1346914

    This book should be of use to you.

    http://www.amazon.com/Performance-Tuning-Server-Dynamic-Management/dp/1906434476

    There are some good reviews for this book from experts like Grant Fritchey.

    M&M

  • July 1, 2011 at 5:57 am

    #1346965

    i found this on redgate a couple of days ago, pretty basic but a good starting point

  • July 1, 2011 at 6:32 am

    #1346987

    Thanks for sharing

    M&M

  • July 1, 2011 at 12:18 pm

    #1347257

    Just building on previous comments here is an example of how to use DMVs. The beauty of this particular example is that you may use the created applet for years to come.

    http://www.databasejournal.com/features/mssql/article.php/3897021/SQL-Server-DMVs-in-Action.htm

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • July 1, 2011 at 12:34 pm

    #1347265

    Here are a few more. Tim Ford and Louis Davidson have great books on the topic.

    http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=sql+dmv&x=0&y=0

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply