Hi

I need small clarification on your query. These transactions are hitting from the application to database ?

I have my requirement as below, could you please check it and confirm that the query you have posted gives me the result of mine...

My Requirement as follows :

/ * Can you please find out whether this is possible in sql server 2005/2008/2012. */

1.Can we get the number of hits that came from application in any given time (hour, minute or day)

2.Can we get the number of hits per second?

3.What is the input/output size during each hit.