Query: CPU daily average < 2%

Description

Identify instances where the daily average CPU utilization is less than 2% in your AWS ElastiCache Redis clusters. This is useful in understanding underutilized resources, which can help optimize costs and resource allocation.

Query

Tables used in this query:

• aws_elasticache_redis_metric_engine_cpu_utilization_daily

SQL