Toad World® Forums

How do you benchmark a workload?


I have received a log from my Sybase database DBA. This the database log containing select statements, stored procedures, update statements, thread numbers (or process ID associated with each user), and response time associated with each thread number. This log contains applications running against the database within 24 hours.

How do you perform scalability testing in BMF for Databases in this scenario? Should I take each select statement from this log and apply various user load in BMF? In a real world, this is not how it works. For example, a user who places an order, the order entry application executes multiple (related) transactions in order to process that order. Would you suggest that I group related transactions from this log file (based on the thread number), and then run each group using various loads in BMF? This is a time consuming effort, so I was wondering if BMF can automate this.