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


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


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



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

    select count(*) as TotalConnections from master..sysprocesses

    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