Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com

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

Introductions

Class Introductions

Advanced Projection Design

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

Projection Design for Optimal Queries

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

Parameters and Settings

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

Query Analysis

Performance Monitoring and Tools

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

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