Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mostly accessed objects in database Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 11:24 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:00 PM
Points: 1,786, Visits: 3,237
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,


Post #1435071
Posted Monday, March 25, 2013 11:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 12,905, Visits: 32,158
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1435077
Posted Monday, March 25, 2013 12:26 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:00 PM
Points: 1,786, Visits: 3,237
Thanks much!
Post #1435087
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse