Query: CacheHit sum below 10

Description

The query is used to monitor the performance of your AWS ElastiCache Redis clusters by identifying instances where the sum of cache hits falls below 10 in an hour. This can help you pinpoint potential issues and optimize your cache usage for improved application performance.

Query

Tables used in this query:

• aws_elasticache_redis_metric_cache_hits_hourly

SQL