Advanced Performance Tuning Workshop

ADVANCE PERFORMANCE TUNING AND RESOURCE MANAGEMENT

Vertica is an advanced analytics platform that typically runs queries very quickly without the need for extensive tuning.  However, it also has powerful features to improve query performance should the need arise.

• Are you experiencing query performance degradation? Do queries that use to run fast seem slower?
• Do you need help in understanding where to start when it comes time to boost query performance? 
• Are you concerned that your workload might not be best using cluster and network resources in order to achieve results?
• Does one user or one set of queries hog all the resources in your cluster slowing other user workload?
• Do you just want your queries to run faster in order to better serve the requirements of the business?

If the answer to any of these questions is yes, plan to join us for a half-day of Vertica advanced training.

In this workshop, Vertica experts will talk about how to investigate query performance issues, advance projection design, how encoding affect the query performance, how to set direct queries to overwrite Optimizer's plans and no the less how resource manager works and how can you tune the resource pool settings to get better query performance and concurrency.