Monitoring the Long running query in Azure Redis cluster

Simanchala M [External], Technology 0 Reputation points
2024-04-17T16:41:00.62+00:00

Hi Team,

We have an application based on Appservice+Java and Azure SQL.For Caching service we provisioned the Redis cluster, and we need to setup the monitoring process for long running queries, response time taken for each request.

Can you please provide us some inputs based on this and it will be very helpful for us,

Mainly how to monitor the long running queries in Redis cluster and to monitor req/response object size.

Thanks,

Simanchala

Azure Cache for Redis
Azure Cache for Redis
An Azure service that provides access to a secure, dedicated Redis cache, managed by Microsoft.
215 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,241 Reputation points Microsoft Employee
    2024-04-17T21:41:15.35+00:00

    @Simanchala M [External], Technology Thank you for reaching out.

    Using the SLOWLOG GET command, you can measure expensive commands being executed against the server.

    Customers can use a console to run these Redis commands to investigate long running and expensive commands.

    • SLOWLOG is used to read and reset the Redis slow queries log. It can be used to investigate long running commands on client side. The Redis Slow Log is a system to log queries that exceeded a specified execution time. The execution time doesn't include I/O operations like talking with the client, sending the reply, and so forth, but just the time needed to actually execute the command. Customers can measure/log expensive commands being executed against their Redis server using the SLOWLOG command.

    https://learn.microsoft.com/en-us/azure/azure-cache-for-redis/cache-troubleshoot-timeouts#long-running-commands

    Regards,

    Oury