Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Capture logical reads for a specific table for specified duration Expand / Collapse
Author
Message
Posted Wednesday, August 29, 2012 11:22 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 24, 2014 10:20 PM
Points: 231, Visits: 722
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.
Post #1352009
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse