SQL Server Performance

Table Usage Statistic

Discussion in 'SQL Server 2005 General DBA Questions' started by jn4u, Feb 3, 2010.

  1. jn4u Member

    What is the simplest way to get Table Usage Statistic. Numbers of reads, writes, updates etc.
  2. Elisabeth Redei New Member

    Hello,
    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.
    Kind Regards,
    /Elisabeth

Share This Page