Query: CacheHit hourly average < 100

Description

Explore the performance of your AWS ElastiCache Redis clusters by identifying instances where the hourly average of cache hits is less than 100. This can help pinpoint potential areas of concern and optimize the usage of your cache clusters.

Query

Tables used in this query:

• aws_elasticache_redis_metric_cache_hits_hourly

SQL