Post reply

Recording reads/writes per table

  • August 17, 2006 at 9:35 am

    #113270

    Does anyone know how to figure out how many reads/writes per second a certain database table gets? 

    I'm assuming there are either native or third party tools that provide this info, but I haven't seen anything of the sort when searching through google. 

  • August 21, 2006 at 6:25 am

    #655833

    Try using Performance Monitor, look under PhysicalDisk monitors.  I believe you will find what you are looking for.

  • August 21, 2006 at 6:28 am

    #655834

    After I posted that, I realized you were after a specific table.  I don't think Perf Mon has what you need for that.

  • August 21, 2006 at 6:32 am

    #655836

    I don't know of any third party tools, but you could write a trigger to increment a counter in a table for either Update, Insert, Select, or Delete.  That would of course have a performance impact that may or may not cause an issue.

  • August 21, 2006 at 1:56 pm

    #655974

    You can also try to use Profiler.

    Choose Stored procedures:completed and TSQL:BatchCompleted events, select TextData, Reads, Writes columns. Save trace to a table. When you will finish tracing, you can query your table like this:

    select sum(reads), sum(writes)

    from trace_table

    where TextData like 'table_name%'

     

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

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