5

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!

3

OK, here is a cheap way, but it is not what I really want (I really want nice charts and graphs!):

-- First PASS
DECLARE @First BIGINT
DECLARE @Second BIGINT
SELECT @First = USER_SEEKS
FROM sys.dm_db_index_usage_stats
where object_id=14473333 AND index_id = 1

WAITFOR DELAY '00:00:15'

SELECT @Second = USER_SEEKS
FROM sys.dm_db_index_usage_stats
where object_id=14473333 AND index_id = 1
SELECT (@Second - @First) 'TableSeeks'
GO

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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