Capture logical reads for a specific table for specified duration

• praveen_vejandla

  SSCrazy

  Points: 2069

  More actions

  August 29, 2012 at 11:22 pm

  #393050

  Hi,

  For a given timeframe, is there anyway to capture what are the top 10 tables by logical reads, logical writes etc?

  DMVs can give top queries consuming most of the logical reads/writes but is there way to get such data grouped by tables or indexs for specific duration?

  Thanks.