Tracking Database hits or calls?

[ezecastle]

What is the best way to find out how many database calls or hits you are getting on a daily basis?

Perfmon? System monitor? Or is there a DBCC command that may tell you? I'm trying to find out how many transactions or calls we get on a daily basis.

Thanks.

[MAK]

select * from master..sysperfinfo where counter_name like '%Transactions/sec%'

[ezecastle]

Thank you! Thats what i needed.

thanks again.

[rmiao]

You may know that the number is same as in perfmon and it's not daily based.