Which tables are being hit the most?

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.

In SSMS under Securty, you can create Audits

Works for me thanks

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