Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Require help to get number of hits to sql server 2008 R2 in a day Expand / Collapse
Posted Thursday, October 17, 2013 4:04 AM



Group: General Forum Members
Last Login: Tuesday, July 19, 2016 4:34 AM
Points: 2,850, Visits: 4,076
navakanth_yenreddy (10/16/2013)

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.

I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1505567
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse