PERF 12. How do you ensure the capacity and throughput of your databases matches demand?
The amount of demand placed on a system often varies over different cycles: product lifecycle such as launch, growth, etc.; temporal cycles such a time of day, weekday or month, etc.; unpredictable cycles such as seen with social media; and predictable cycles such as television episodes. Having insufficient database capacity and throughput to meet workload can degrade user experience and, at its worst, lead to system failure.

 

Best practices:

 Planned Plan for future capacity and throughput based on metrics and/or planned events.
 Automated Automate against metrics.