SQL: How can I get the number of executed queries per database or hour or ...?

Question

Is there any way to see how many queries are executed in like every hour, or per database / hour, or average number of queries on a day, or ...whatever is interesting?

Just for statistics.. I like numbers. I can't just start a trace with Sql Server Profiler, because the UI will crash when too many queries come by.

Does SQL keep track of some basic 'executed queries statistics' somewhere, or are there any tools I can use to get this information?

_{(I use SQL Server 2008 R2)}

Answer 1

This should work:

select * 
from sys.dm_os_performance_counters
where counter_name = 'Batch Requests/sec'

It actually returns the total Batch Requests. You poll this number periodically and then use this calculation:

ReqsPerSec = (curr.Value - prev.Value) / (curr.time - prev.time)