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:

  • Performance Reporting
  • Performance Basic
  • Performance Premium

The below table shows the differences:

 

Performance Reporting

Performance Basic

Performance Premium

Statistics Review

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

Performance Consulting

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


Statistics Review

During the Statistics Review 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.

Performance Consulting

For both Performance Basic and Performance Premium, Exasol support will analyze incoming performance requests on-demand. 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 Performance Reporting, Performance Basic, and Performance Premium.

Support Level "Platinum" includes 2 days per year of Performance Consulting.