After running the load test customer’s often download the database and run queries to determine their sites performance. Here are some common SQL queries to get you started:
# Analyze the avg, max, and min time for each step in a transaction SELECT step, COUNT(*), AVG(time_active), MAX(time_active), MIN(time_active) FROM step GROUP BY step # General query to look at loading of objects SELECT path, COUNT(*), AVG(time_active) FROM object GROUP BY path ORDER BY AVG(time_active) DESC # Get error msg grouped by error, host, status SELECT err_msg, host, status_code, COUNT(*), AVG(time_active) FROM object GROUP BY err_msg, host, status_code
We hope that you find these a useful starting point for your load testing analysis.
No tags
