Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, October 17, 2013 4:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
navakanth_yenreddy (10/16/2013)
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.
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
Post #1505567
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse