Post reply

disadvantages of DMVs

  • July 23, 2012 at 6:44 am

    #264132

    Hi,

    What I know is the use of DMVs are all good. Say for ex, it doesnt create any blocking/locking since we query the system tables etc.

    However does it have any disadvantages?

    Thanks.

  • July 25, 2012 at 9:53 am

    #1517464

    The biggest disadvantage in my opinion is the data in the DMVs is reset upon SQL restart. So if you are trying to do trending type of reports, you'll need to capture this DMV data on a regular basis to a DW somewhere.



    A.J.
    DBA with an attitude

  • July 30, 2012 at 12:49 pm

    #1519356

    DMV data is not guaranteed to be accurate at the time of retrieval. They are updated asynchronously.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

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