DB2 Performance Advice: TX/Sec

Frankly, rates are not very helpful when it comes to tuning, but they are entertaining. You see, your business may be busier on Monday than it is on Wednesday. Or, your business may be busier at the end of a month versus the middle of a month. Rates can vary depending upon demand for services.

When evaluating database tuning efficiency and effectiveness, cost metrics provide a much better indicator of tuning success or failure. A number of cost metrics to help you assess the effectiveness and efficiency of your tuning efforts:

• Database Bufferpool Logical Reads per Transaction
• Sorts per Transaction
• Hash Joins per 1,000 Transactions

Since some people like to monitor their databases to see how fast they are going, it provides "Transactions Per Second" as a performance metric for entertainment purposes only. The value shown is the delta of transaction count activity (COMMIT_SQL_STMTS + ROLLBACK_SQL_STMTS) since the prior measurement was taken. Enjoy.

---