February 14, 2012 at 3:25 pm
is there any way to get a report of per table I/O usages for a given database. I want to know which tables are heavely used in a particular database.
For e.g. if i have a database with 100 tables. I want a per table I/O usage report.
February 14, 2012 at 3:31 pm
Have you tried looking at this DMV (dynamic management view)?
sys.dm_io_virtual_file_stats
This may help:
http://blogs.technet.com/b/josebda/archive/2009/03/31/sql-server-2008-i-o-performance.aspx
February 14, 2012 at 3:45 pm
Sys.dm_db_index_usage stats will give you reads and updates (and therefore writes) per index, you could use that to give you an idea.
sys.dm_io_virtual_file_stats is at database file level.
---------------------------------------------------------------------
February 16, 2012 at 11:44 am
thank you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply