January 19, 2009 at 1:01 pm
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.
January 20, 2009 at 3:41 am
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/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply