Count of reads per table

  • 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
  • This was removed by the editor as SPAM

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

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply