Count of reads per table

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 24, 2006 at 5:34 am

  #91249

  Hi all.

  Does anyone know of a way to find out how often (over a period of time) each table in a database is read?

  I tried profiler, but can't see any events that will give what I need.

  Thanks

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• August 28, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Shawn Wilson

  Ten Centuries

  Points: 1271

  More actions

  August 30, 2006 at 10:19 am

  #657621

  see this excellent article posted today on this site...

  http://www.sqlservercentral.com/columnists/mmorin/2573.asp