Table usage stats

• davegilboy

  Valued Member

  Points: 53

  More actions

  January 19, 2009 at 1:01 pm

  #205546

  Just wondering if there's an easy way (or just a 'way' for that matter) to get statistics on how often a table is accessed?

  I've been tasked with performance tuning for and it would be very useful to get a list of the most commonly accessed tables. I have a hunch that probably 90% of our transactions use only say 50 tables (our databases contain several hundred), if I could find out which tables these are it would give me a better idea of where to focus for index tuning.

  I'm fairly new to this and not a DBA by trade so I apologise if this is obvious.

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 20, 2009 at 3:41 am

  #929572

  I did a series of posts on analysing indexes on my blog/website - pretty much all you need to know is in there

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/