Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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, April 7, 2016 12:35 PM
Points: 1,910, Visits: 3,580
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 @ 1:27 PM
Points: 14,198, Visits: 37,113
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1435077
Posted Monday, March 25, 2013 12:26 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 7, 2016 12:35 PM
Points: 1,910, Visits: 3,580
Thanks much!
Post #1435087
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse