exa-Nico
Community Manager
Community Manager

What is Performance Services?

We offer a quarterly in-depth analysis of your system statistics by an Exasol specialist. We also offer Ad-Hoc Performance Analysis to make your queries even faster.

The Performance Service can be booked as:

  • Capacity Reporting
  • Performance Basic
  • Performance Premium

The below table shows the differences:

 

Capacity Reporting

Performance Basic

Performance Premium

KPI Report

Yes

Yes

Yes

Delivery

Via screen-share session

Via screen-share session

Via screen-share session

Source

DB statistics

DB statistics

DB statistics

Frequency

Quarterly

Quarterly

Quarterly

Ad-Hoc Analysis

No

Yes

Yes

Delivery

 

Via ticket

Via ticket

Source

 

Depending on issue to be analyzed

Depending on issue to be analyzed

Frequency

 

On demand

On demand

Max Effort

 

6 person days/year

18 person days/year


KPI Reporting

During KPI Reporting an Exasol database specialist reviews several database performance KPIs such as license and database usage, database size and growth, raw data size/RAM comparison and recommendation, index size, cluster resource utilization, and SQL execution duration.

Ad-Hoc Analysis

For both Performance Basic and Performance Premium, Exasol support will analyze incoming performance requests on-demand (Ad-Hoc Analysis). This analysis could include (but is not limited to) the following topics:

  • Identify and improve query runtime
  • Optimize queries
  • Optimize ETL Processes
  • Optimize Distribution Keys and Replication Borders

Access to your system statistics is a prerequisite for the delivery of the Performance Service. This applies to Capacity Reporting, Performance Basic, and Performance Premium.