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: Tuesday, April 15, 2014 9:54 AM
Points: 1,720, Visits: 3,063
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 @ 12:01 PM
Points: 12,744, Visits: 31,074
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: Tuesday, April 15, 2014 9:54 AM
Points: 1,720, Visits: 3,063
Thanks much!
Post #1435087
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse