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: Yesterday @ 4:19 PM
Points: 1,953, Visits: 3,676
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 @ 5:39 AM
Points: 14,469, Visits: 38,083
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: Yesterday @ 4:19 PM
Points: 1,953, Visits: 3,676
Thanks much!
Post #1435087
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse