How can the SysOps administrator accomplish this goal?
Create an Amazon CloudWatch dashboard.
Enable Amazon RDS Performance Insights.
Enable and configure Enhanced Monitoring.
Review the database logs in Amazon CloudWatch Logs.
Explanations:
While creating an Amazon CloudWatch dashboard can help visualize various metrics, it does not specifically provide detailed wait events for database load. It is more suited for monitoring general performance metrics rather than in-depth database analysis.
Enabling Amazon RDS Performance Insights provides detailed information about database load and categorizes it by wait events. This feature allows administrators to analyze and understand performance issues at a granular level.
Enhanced Monitoring provides real-time metrics for the operating system that the RDS instance runs on, but it does not provide detailed information about database load or wait events specific to MariaDB. It focuses more on the underlying system rather than the database itself.
Reviewing the database logs in Amazon CloudWatch Logs can provide some insights into database operations, but it does not categorize database load by detailed wait events. This option is more suited for troubleshooting specific issues rather than analyzing overall database performance.