SQL Server 2008: Measure tps / select statements per second for a specific table?
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