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.
Dont hijack other's post to " post your query" . always use "Add Topic" option. this will increase chances of answers/responses better.
-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done;-)