none
amount of transactions in a period of time on sql server 2000

    Question

  • Is there a native tool (profile,trace,performance) feature I can use to determine the amount of transactions that occur throughout the day? Or is there a system table that keeps track of this(would be preferable .. less strain on the system)?

    I assume figuring out the transaction in a certain period will enable me to calculate the busiest periods...I need to know the busiest period of the day...how do I do this without putting an additional strain on the server (can I use a different machine other than the server to save a trace) ...I need to determine strain on (processor,memory, and disk).

    I also need to get a count on the largest number of users (running transactions) on the server simultaneously.


    Any help/advice would be deeply appreciated

    Friday, March 02, 2007 1:39 AM

Answers

  • Running PROFILER on full day is not a good thing if you still have performance problems, lately.

    http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm - automating such trace.

    Refer:
    select count(*) as TotalConnections from master..sysprocesses
    go

    select substring(db_name(dbid),1,30) as DB_name ,count(*) as Connection
    from master..sysprocesses
    group by substring(db_name(dbid),1,30)

     

    Friday, March 02, 2007 1:55 PM
    Moderator

All replies

  • You need to run profiler for this purpose... there is no system table as such which stores all the transactions... What u can do is.. run profiler and store it as table and query the table as u want... Be sure what all are the data u need to capture... Profiler can cause performance degradation.... Capture only the required data by selecting proper column filter and event

     

    Madhu

    Friday, March 02, 2007 2:01 AM
    Moderator
  • Running PROFILER on full day is not a good thing if you still have performance problems, lately.

    http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm - automating such trace.

    Refer:
    select count(*) as TotalConnections from master..sysprocesses
    go

    select substring(db_name(dbid),1,30) as DB_name ,count(*) as Connection
    from master..sysprocesses
    group by substring(db_name(dbid),1,30)

     

    Friday, March 02, 2007 1:55 PM
    Moderator