Post reply

DMV's

  • August 29, 2010 at 11:36 pm

    #239693

    Hi All,

    Usually how much data does DMV's Hold and how often the data from DMV's gets cleared. I was under the impression when ever the SQL Server starts or machine (server) starts the DMV's holding the information will get cleared, is this right if I'm not. Can any clear me with this issue.

    Thanks,

    Ravi S.

  • August 30, 2010 at 3:00 am

    #1213634

    Hi Ravi ,

    you are right , DMVs are virtual view it does not have its own data. it has limited data access.

    Some DMVs takes data directly from query Plan Cache. So when u resart sql server. Server flushes all Cache query plans.

    Thats why Dmv gives No record.

    Regards

    Mayank tyagi

  • August 31, 2010 at 2:09 am

    #1214084

    Depends on the DMV. Different ones have different rules. Check the entries for the DMVs in Books Online for details.

    Some hold limited data, some don't. Some reflect only current data, some have historical since SQL started. Different for different DMVs.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 21, 2012 at 12:49 am

    #1503778

    Hi Guys,

    Do you have a link with DMV queries? I remember that I have found on this website a link with all the dmv explained per day, but unfortunately i can't find it anymore.

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

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