Get I/O statistics for each table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Get I/O statistics for each table

Author

Topic

chih
Posting Yak Master

154 Posts

Posted - 2010-03-30 : 20:16:16

Hi All,

Is there a way to get I/O (r/w) for each tables?

cheers

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-30 : 22:49:09

It would take a lot of work to gather it and wouldn't be completely accurate.

You can get I/O information of queries via SQL Profiler. You'd then need to get the tables from each. This is where it gets let's accurate as a query can have many tables in it, yet we only get one value for reads and one for writes.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources