EncartaLabs

Vertica Advanced Performance Tuning

( Duration: 2 Days )

The HP Vertica Advanced Performance Tuning training course provides an intensive deep-dive into the process of diagnosing and optimizing query performance within an HP Vertica deployment. You will learn how to tune and simplify database queries, modify resource settings, monitor and update statistics, and interpret the output of the Workload Analyzer.

Attending HP Vertica Essentials course or equivalent experience with the HP Vertica Analytics platform

System Administrators, Database Administrators, and Application Developers

COURSE AGENDA

1

Introductions

  • Class Introductions
2

Advanced Projection Design

  • Database Design, Manual Projection Design, Run Length Encoding, Pre-Join Projections, Live Aggregate Projections, Expressions in Projections
3

Projection Design for Optimal Queries

  • Database Designer in Incremental Mode, Optimize Joins, Optimize Group By, Correlate Columns, Grouped Columns, High Cardinality Columns
4

Parameters and Settings

  • guration Parameters, ResourceSystem and Data Collector Tables, Con Management Settings, Dynamic Resource Pool
5

Query Analysis

6

Performance Monitoring and Tools

  • Research Longest Running Queries, Workload Analyzer, Delete and Purge, I/O Throughput, Network Performance, CPU Performance, Locks
7

Query Optimization

  • Restructure Queries, Count Distinct, WITH Clause

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top