Best Practice (Good)
Store processing times for queries and other database operations (start and end times for batch processes, scripts, stored procedures, etc.) in a related database to monitor the performance of these actions during the life of a database system.
Typical Practice (Bad)
Collect database processing benchmarks (start and end times, batch processing, queries, etc.) only during performance audits or process improvement initiatives.
Benefits: Allows database performance to be analyzed over a long period of time and provides immediately accessible, actionable data to use to identify specific areas for improvement within the database system. Also helps to establish more reliable data for median or mean runtimes and processes.