Number of transactions processed by a server?

Is there any way to get the number of transactions a server has
processed? I'd like to run that and then see how many transactions
where processed over the next 5 minutes. Is there a way to do that?
-JohnYou can start Profiler and profile the Commited Transactions, another
possibility would be he log Exlorer from Lumigent.
HTH, Jens Smeyer.
http://www.sqlserver2005.de
--
"John Baima" <john@.nospam.com> schrieb im Newsbeitrag
news:8t2261h1udi4tlqo3sbd1mr1thctg7dl66@.
4ax.com...
> Is there any way to get the number of transactions a server has
> processed? I'd like to run that and then see how many transactions
> where processed over the next 5 minutes. Is there a way to do that?
> -John|||There is a perfmon counter for Sql Server under each database for
transactions per second.
Andrew J. Kelly SQL MVP
"John Baima" <john@.nospam.com> wrote in message
news:8t2261h1udi4tlqo3sbd1mr1thctg7dl66@.
4ax.com...
> Is there any way to get the number of transactions a server has
> processed? I'd like to run that and then see how many transactions
> where processed over the next 5 minutes. Is there a way to do that?
> -John|||I'm not aware of a readily-available counter somewhere, but one option might
be to run a trace for the SQLTransaction event and filter on 'Begin' for the
EventSubClass. If you run the trace during the five-minute period, counting
the number of rows in the trace table at the end will give you the count of
transactions that occurred. In my tests, this count appears to be
equivalent to the counts returned by the Total Transactions/sec performance
counter.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"John Baima" <john@.nospam.com> wrote in message
news:8t2261h1udi4tlqo3sbd1mr1thctg7dl66@.
4ax.com...
> Is there any way to get the number of transactions a server has
> processed? I'd like to run that and then see how many transactions
> where processed over the next 5 minutes. Is there a way to do that?
> -John