Require help to get number of hits to sql server 2008 R2 in a day

Question

Require help to get number of hits to sql server 2008 R2 in a day

Sumit Rastogi

SSC Eights!

Points: 838
More actions
July 11, 2013 at 6:17 am

#279891

Hello All,
Please help me to find out number of hits to sql server 2008 R2 in a day.
Thanks,
Sumit Rastogi:-)

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

HanShi SSC-Dedicated Points: 33507 More actions · Answer 1

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’! **

Sumit Rastogi SSC Eights! Points: 838 More actions · Answer 2

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:-)

navakanth_yenreddy SSC-Addicted Points: 475 More actions · Answer 3

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.

navakanth_yenreddy SSC-Addicted Points: 475 More actions · Answer 4

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.

navakanth_yenreddy SSC-Addicted Points: 475 More actions · Answer 5

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.

navakanth_yenreddy SSC-Addicted Points: 475 More actions · Answer 6

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.

navakanth_yenreddy SSC-Addicted Points: 475 More actions · Answer 7

navakanth_yenreddy

SSC-Addicted

Points: 475

October 16, 2013 at 11:20 pm

#1659123

.

navakanth_yenreddy SSC-Addicted Points: 475 More actions · Answer 8

navakanth_yenreddy

SSC-Addicted

Points: 475

October 16, 2013 at 11:21 pm

#1659124

Please help...

navakanth_yenreddy SSC-Addicted Points: 475 More actions · Answer 9

navakanth_yenreddy

SSC-Addicted

Points: 475

October 16, 2013 at 11:21 pm

#1659125

Please Help...

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 10

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;-)