Which tables are being hit the most?

SQL Server Administration
1

We're trying to determine, which tables in the database get the most Selects (selects per hour or something by table). Same for inserts and updates.

Any ideas how we can do this?

We are making some changes to the DB and for performance reasons need to know how active they are.

2

In SSMS under Securty, you can create Audits

3

Works for me thanks

4

You can also look at the index usage stats. I've found that useful when I've needed to that.

5

thanks