Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

E.g.

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

share|improve this question
2  
Have you looked into using Data Collection? –  Jon Seigel Jul 17 '13 at 17:07
    
@JonSeigel Thanks! I have been using SQL Server for too long (since 4.21), so I miss cool new features like this! Extending it for my purpose looks a hassle to learn, and I will say that it is too many darn steps to set up (file system access? user mapping? pleeeease!) But I will look into it! –  samsmith Jul 18 '13 at 1:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.