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

  • Hello All,

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

    Thanks,

    Sumit Rastogi:-)

  • 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’! **
  • 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:-)

  • 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.

  • 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.

  • 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.

  • 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.

  • .

  • Please help...

  • Please Help...

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

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

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