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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
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
up vote 0 down vote accepted

We implemented redgate sql monitor, and a custom monitor in that, with a tsql statement that grabs the counter for that object (table, index, whatever) waits a minute, grabs counter again and subtracts. Works v nice!

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.