In SQL Server 2008: Measure tps / select statements per second for a specific table? , the question was "how to do it"
OK, so I can do it.... but I want automated, pretty charts, so I can easily find and watch over days tps by table (to guide us in optimization work, etc).
Yes, we could "roll our own" and write all kinds of reports, etc. but that looks to be 1-n days of work.
Is there a tool to automate all or some of this?
chart: TPS by table for database N (with timeline over 1 hr, 24 hrs, 7 days, etc) chart: Top five tables w hottest tps etc