March 25, 2013 at 11:24 am
Is there a way or a query that I can find out in the past year what tables and view are most accessed or heavily used?
Thanks,
March 25, 2013 at 11:42 am
you can use some index stats to find those kinds of totals since the last time the service was stopped and started;
it's not kept aywhere else unless you start capturing it for yourself int he future.
see this thread for code examples, and a lot of good info:
fetch tables most often queried
Lowell
March 25, 2013 at 12:26 pm
Thanks much!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply