Detecting and Resolving Presto Performance Hurdles

In this session, Goutam will explore advanced monitoring strategies for detecting and resolving performance issues in Presto clusters. We will delve into specific metrics and tools that can help identify issues such as query latency spikes, resource contention, and node failures. Through real-world examples and case studies, attendees will learn how to optimize their monitoring setup to proactively detect and resolve issues, ensuring smooth operation and high performance of their Presto deployments.

The session will begin with an overview of Presto clusters and the critical role of monitoring in optimizing performance. We will then discuss common performance hurdles, including query latency spikes, resource contention, and node failures, highlighting the need for proactive monitoring. Next, Goutam will delve into key metrics that should be monitored, such as query execution times, resource utilization, and network latency, and how these metrics can help in identifying and addressing performance issues. Goutam will also provide a brief overview of monitoring tools like Prometheus, Grafana, and Presto’s built-in metrics, showcasing their capabilities in collecting and analyzing monitoring data. Before the end of session attendees will explore real-world examples demonstrating the effectiveness of these monitoring strategies in detecting and resolving performance issues in Presto clusters.