Which solution will meet these requirements with the LEAST administrative oversight?
Use Amazon DevOps Guru insights.
Use AWS CloudTrail.
Use Amazon CloudWatch Logs.
Use Amazon Aurora Database Activity Streams.
Explanations:
Amazon DevOps Guru is a fully managed service that uses machine learning to provide insights into application performance and resource utilization. It can automatically identify high CPU utilization and suggest remediation actions with minimal administrative oversight.
AWS CloudTrail records API calls made on your account but does not provide insights into database performance or CPU utilization. It is more focused on auditing and compliance rather than performance monitoring.
Amazon CloudWatch Logs can provide logs for monitoring, but it requires manual setup to analyze specific metrics related to CPU utilization or database latency. It does not inherently identify the root cause without additional configuration.
Amazon Aurora Database Activity Streams provides real-time data on database activity, which can help in monitoring performance issues, but it still requires setup and management. It is not as automated as DevOps Guru for identifying high CPU utilization.