Discussion in 'SQL Server 2005 General DBA Questions' started by jn4u, Feb 3, 2010.
What is the simplest way to get Table Usage Statistic. Numbers of reads, writes, updates etc.
Have you had a look at sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats (doc'ed in Books Online)?
If you do a web search, you will find numerous scripts that will provide you with output that is somewhat easier to penetrate than the raw output.
Separate names with a comma.