Design a database monitoring system that tracks cloud database resource consumption and optimizes inefficient queries to reduce compute and storage costs.
Deploy managed cloud database.
Monitor database CPU and I/O usage.
Identify high-cost queries.
Optimize queries and indexing strategies.
Measure cost impact after optimization.
Simulate heavy transaction workload.
Compare performance before and after tuning.
Generate cost efficiency report.
Document optimization techniques and findings.
