Post reply

information about 'max_logical_writes' column in sys.dm_exec_query_stats

  • June 10, 2014 at 3:22 am

    #292159

    Hi Experts,

    Just wanted to know more about the column 'max_logical_writes' in the DMV 'sys.dm_exec_query_stats'

  • June 10, 2014 at 3:24 am

    #1720309

    What, specifically do you want to know, beyond what is documented in Books Online for that DMV.

    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 10, 2014 at 3:42 am

    #1720313

    Thanks got the info in books online, however just wanted to know whether it would be feasible to run this DMV during production hours...

  • June 10, 2014 at 3:47 am

    #1720318

    Sure, why wouldn't it be?

    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

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

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