|
ferrethouse
Constraint Violating Yak Guru
306 Posts |
 Posted - 08/16/2012 : 12:14:30
|
| I know the answer to that question is no but I want to gauge the extent that my metrics are of value. I used a tool called SQLStress to determine how many transactions/second various AWS instances could support. I found that the cc2.8xlarge instance could support 12190 transactions per second. I then turned on perfmon on my local production server and checked the SQL Server transactions/second metric. It averages about 1000 transactions/second. But I suspect that the transactions contained in the SQLStress software are less complex than many of the transactions performed by our application so I don't know how much comfort I can derive from the analysis. Your thoughts? |
|
Are all transactions created equally?
