Workload analyzer for monitoring and optimizing workload performance

One or more non-transitory computer-readable media storing instructions which, when executed by one or more hardware processors, cause:

• identifying a first workload associated with a first timeframe, wherein the first workload includes a first set of database queries executed within the first timeframe;
• performing a comparison of the first workload associated with the first timeframe and at least one other workload associated with a different timeframe, wherein the at least one other workload includes a second set of database queries executed within the different timeframe;
• determining, based on the comparison of the first workload associated with the first timeframe and the at least one other workload associated with the different timeframe, differences between (a) an aggregate distribution between the first set of database queries and the second set of database queries and (b) performance metrics associated with at least one of individual database queries or query statements that are common to the first set of database queries and the second set of database queries;
• generating, based on the differences, tuning advice to address a cause of degraded performance between the first workload and the at least one other workload;
• tuning, by a query optimizer, at least one database query based on the tuning advice;
• and
• after tuning, executing the at least one database query.

A system comprising:

• one or more hardware processors;
• one or more non-transitory computer-readable media storing instructions which, when executed by one or more hardware processors, cause:
• identifying a first workload associated with a first timeframe, wherein the first workload includes a first set of database queries executed within the first timeframe;
• performing a comparison of the first workload associated with the first timeframe and at least one other workload associated with a different timeframe, wherein the at least one other workload includes a second set of database queries executed within the different timeframe;
• determining, based on the comparison of the first workload associated with the first timeframe and the at least one other workload associated with the different timeframe, differences between (a) an aggregate distribution between the first set of database queries and the second set of database queries and (b) performance metrics associated with at least one of individual database queries or query statements that are common to the first set of database queries and the second set of database queries;
• generating, based on the differences, tuning advice to address a cause of degraded performance between the first workload and the at least one other workload;
• tuning, by a query optimizer, at least one database query based on the tuning advice;
• and
• after tuning, executing the at least one database query.