Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Nroblex
Starting Member
17 Posts |
 Posted - 2009-04-16 : 10:02:48
|
| Hello Gurus!Do you know if there is a way to find out the statistics for which table are most frequently used in a database.I have a relativly large database with about 200 tables, and I would like to list the table most frequently used in the database. Many thanks in advance!//Nroblex from Sweden |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-04-16 : 11:23:00
|
| It depends what you mean by used (writes/reads? [if reads then scans/seeks?]), but if you look at the Dynamic Management Views, they will give you query and index usage, which may give you the answer you are after. |
 |
|
|
|
|
|
Most frequently used table ?