Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
tribune
Posting Yak Master
105 Posts |
Posted - 2004-03-05 : 16:59:31
|
I need to calculate the transaction per minute count for five databases to help project future growth. Does anyone know how to accurately track this information? Can I use SQL profiler? How about recording long-term TPM data? Thanks |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-05 : 17:33:53
|
You can track transactions per sec in Performance Monitor. Open up PerfMon on the database server. Click add. Select SQLServer:Databases object. Then select transactions/sec instance. You will probably want to log the information to a file. You can do this through the counter logs which is in the left pane of the window.Tara |
|
|
tribune
Posting Yak Master
105 Posts |
Posted - 2004-03-05 : 17:43:20
|
Thanks Tara |
|
|
|
|
|