There is a discussion how to measure activity against an entire DB: https://stackoverflow.com/questions/5019593/sql-server-2008-transaction-per-second-for-specific-database
My question is narrower.
We are working on performance optimization of our application. To see how we are doing, we need to measure SELECT operations per second/minute/hour (prefer hour) on a specific table. (This way we can measure before and after implementing the optimization, to see how we are doing.)
What is the method or tool to do this?
Thank you!
sys.dm_db_index_usage_stats