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, July 11, 2013 6:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 12:42 AM
Points: 24, Visits: 116
Hello All,

Please help me to find out number of hits to sql server 2008 R2 in a day.

Thanks,
Sumit Rastogi
Post #1472535
Posted Thursday, July 11, 2013 6:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 2,448, Visits: 2,989
What do you define as a "hit"?
Every executed stored procedure, every executed batch, or every executed statement, or every active connection login, or....?

The most basic(?) way to look at this is to run a Server Side Profiler Trace for 24 hours and store the results to a file. This could generate a lot of data and has a performance impact though. So if you use this, keep monitoring diskspace and server performance.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1472547
Posted Thursday, July 11, 2013 7:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 12:42 AM
Points: 24, Visits: 116
Hi,

I meant that number of transactions in a database,

I got the answer by some R & D:

select * FROM sys.dm_os_performance_counters
where Ltrim(rtrim(object_name)) = 'SQLServer:Databases'
and instance_name = 'DBNAME' -- Give the Database Name
and counter_name = 'Transactions/sec'

It will give me the number hits per second for a database named 'DBNAME'.

Thanks,
Sumit

Post #1472566
Posted Wednesday, October 16, 2013 11:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:49 AM
Points: 7, Visits: 24
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.
Post #1505480
Posted Wednesday, October 16, 2013 11:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:49 AM
Points: 7, Visits: 24
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.
Post #1505481
Posted Wednesday, October 16, 2013 11:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:49 AM
Points: 7, Visits: 24
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.
Post #1505482
Posted Wednesday, October 16, 2013 11:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:49 AM
Points: 7, Visits: 24
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.
Post #1505483
Posted Wednesday, October 16, 2013 11:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:49 AM
Points: 7, Visits: 24
.
Post #1505484
Posted Wednesday, October 16, 2013 11:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:49 AM
Points: 7, Visits: 24
Please help...
Post #1505485
Posted Wednesday, October 16, 2013 11:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 4:49 AM
Points: 7, Visits: 24
Please Help...
Post #1505486
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse