Search code examples
sql-servert-sqlstatisticsfillfactor

How to find out SQL Server table's read/write statistics?


Is there a way to find a statistics on table read and write count on SQL Server 2005/2008?

I am specifically looking for DMVs/DMFs without using triggers or audits.

The goal here is to find out appropriate fill factor for indexes - got an idea from this article (Fill Factor Defined).


[UPDATE] There is a follow up question on ServerFault
How to determine Read/Write intensive table from DMV/DMF statistics


Solution

  • Remember 'table' means the clustered index or the 'heap'.