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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2008-09-03 : 02:23:07
|
| Hi everyone,it's quite often that someone ask me about the number of transaction per day in my company. but i have no idea how to get this number.I know to use perfmon to get transaction/sec. but how about per hour/day/month. is there a query to do it?Thank you in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-03 : 09:14:36
|
| You have to estimate with that counter. |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-02 : 22:20:33
|
| 1) Do you need for one user database or total transaction/sec?If you need that information just just once. When you load csv it shows Time tab click on it and scroll it to check for one one hour. ORYou can collect perfmon data in SQL server table directly (based on ur server workload) or use csv and import it into database table and then you can run query to average one hour, week, or month. |
|
|
|
|
|
|
How to get number of transaction per day