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