# of transactions in a single day

[R7Dave]

Hello -

This was a question asked of me as a DBA...


Is there any way to quantify how many of these distinct transactions are completed on a daily basis?


I looked into Profiler but still not sure these results will be accurate for what is needed.

Here is what I have...


Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Thanks in advance for any help

Dave

 

[mrdenny]

Perfmon has counters which track the number of transactions per second. Take the average and do a little math.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog