Counting transactions

Is there a way to count how many transactions our SQL server handles a day?
an hour? etc etc'
thanksYou can get the transactions/sec from System Monitor/Perf
Mon using SQLServer:Databases and the transactions/sec
counter which seems like it won't really give you the total
picture you want. You could also get more detailed
transaction information from sysperfinfo which measures
since the last time SQL started, e.g.
SELECT *
FROM sysperfinfo
WHERE counter_name like '%trans%'
You could check these numbers daily or hourly - put them in
another table table with the time, date - to calculate the
transactions.
-Sue
On Thu, 18 Sep 2003 18:31:14 -0700, "Richard King \(SCA\)"
<google@.walkersca.com> wrote:
>Is there a way to count how many transactions our SQL server handles a day?
>an hour? etc etc'
>thanks
>|||Richard,
Basically I go in-line with the views of Sue. But understand that
transaction/sec counter will give you the active number of transactions in
the past one second only. The values will not be indicative if you were to
take it in intervals of time. What I can think of is to use a log counter
using the "perfmon". And then use the log file created (can be a csv file)
to get the trends of the transactions in your system. Even the sysperfinfo
gives you the same information.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:7frkmv84ou61jk34u6agiqn4e39isid930@.4ax.com...
> You can get the transactions/sec from System Monitor/Perf
> Mon using SQLServer:Databases and the transactions/sec
> counter which seems like it won't really give you the total
> picture you want. You could also get more detailed
> transaction information from sysperfinfo which measures
> since the last time SQL started, e.g.
> SELECT *
> FROM sysperfinfo
> WHERE counter_name like '%trans%'
> You could check these numbers daily or hourly - put them in
> another table table with the time, date - to calculate the
> transactions.
> -Sue
> On Thu, 18 Sep 2003 18:31:14 -0700, "Richard King \(SCA\)"
> <google@.walkersca.com> wrote:
> >Is there a way to count how many transactions our SQL server handles a
day?
> >an hour? etc etc'
> >
> >thanks
> >
>