Workload distribution optimizer

Abstract

Workload distribution is automatically optimized. Cost penalty amounts imposed on executing a database operation transaction by current and alternative processing pathway options are determined as a function of execution response times that exceed a service level agreement time limit. Respective computer processing hardware costs are determined for executing the database operation transaction via each of the current and alternative processing pathway options. Respective licensing costs are determined for migrating execution of the database operation transaction to each of the alternative processing pathway options. Accordingly, the current or alternative middleware option that has a lowest total combined cost of licensing costs, computer processing hardware costs and service level agreement penalty costs is chosen as the path for execution of the database operation transaction.

What is claimed is: 
     
         1 . A computer-implemented method, comprising:
 obtaining a response time feed value for a first middleware operating system to execute a first read-only query operation of a plurality of read-only query operations for execution against a database;   in response to determining that the response time feed value obtained for the first middleware operating system executing exceeds a time limit, identifying each of a plurality of alternative middleware operating systems that are different from the first middleware operating system;   determining respective cost penalty amounts for executing the plurality of read-only query operations by the first middleware operating system and each of the alternative middleware operating systems exceeding the time limit; and   migrating execution of a second read-only query operation of the plurality of read-only query operations to a one of the alternative middleware operating systems that has a lowest total combined cost of licensing costs, computer processing hardware costs, and the cost penalty amounts.   
     
     
         2 . The computer-implemented method of  claim 1 , wherein the first read-only query operation comprises an operation of an input structured query language (SQL) query task. 
     
     
         3 . The computer-implemented method of  claim 1 , wherein the hardware costs comprise costs selected from a group consisting of: hardware equipment acquisition costs; hardware equipment power costs; hardware equipment maintenance costs; software costs; and differential labor costs. 
     
     
         4 . The computer-implemented method of  claim 1 , wherein the licensing costs are selected from a group consisting of: site license costs; host license costs; instance license costs; and migration costs. 
     
     
         5 . The computer-implemented method of  claim 1 , wherein the time limit comprises a response time percentile index value. 
     
     
         6 . The computer-implemented method of  claim 5 , further comprising determining a value of at least one of the cost penalty amounts in response to determining that a percentage of transaction response times for executing the plurality of read-only query operations exceeds the response time percentile index value during an execution time period. 
     
     
         7 . The computer-implemented method of  claim 1 , wherein the respective cost penalty amounts are based on service level agreement (SLA) penalty costs. 
     
     
         8 . A system, comprising:
 a computer processor, a computer-readable storage medium in communication with the computer processor, and program instructions stored on the computer-readable storage medium, the program instructions executable by the computer processor to:   obtain a response time feed value for a first middleware operating system to execute a first read-only query operation of a plurality of read-only query operations for execution against a database;   in response to determining that the response time feed value obtained for the first middleware operating system executing exceeds a time limit, identify each of a plurality of alternative middleware operating systems that are different from the first middleware operating system;   determine respective cost penalty amounts for executing the plurality of read-only query operations by the first middleware operating system and each of the alternative middleware operating systems exceeding the time limit;   determine respective computer processing hardware costs for executing the plurality of read-only query operations via the first middleware operating system and each of the alternative middleware operating systems;   determine respective licensing costs for migrating execution of the plurality of read-only query operations to each of the alternative middleware operating systems from the first middleware operating system; and   migrate execution of a second read-only query operation of the plurality of read-only query operations to a one of the alternative middleware operating systems that has a lowest total combined cost of respective ones of the licensing costs, the computer processing hardware costs, and the cost penalty amounts.   
     
     
         9 . The system of  claim 8 , wherein the first read-only query operation comprises an operation of an input structured query language (SQL) query task. 
     
     
         10 . The system of  claim 8 , wherein the hardware costs comprise costs selected from a group consisting of: hardware equipment acquisition costs; hardware equipment power costs; hardware equipment maintenance costs; software costs; and differential labor costs. 
     
     
         11 . The system of  claim 8 , wherein the licensing costs are selected from a group consisting of: site license costs; host license costs; instance license costs; and migration costs. 
     
     
         12 . The system of  claim 8 , wherein the time limit comprises a response time percentile index value. 
     
     
         13 . The system of  claim 12 , wherein the program instructions are executable to determine a value of at least one of the cost penalty amounts in response to determining that a percentage of transaction response times for executing the plurality of read-only query operations exceeds the response time percentile index value during an execution time period. 
     
     
         14 . The system of  claim 8 , wherein the respective cost penalty amounts are based on service level agreement (SLA) penalty costs. 
     
     
         15 . A computer program product, comprising:
 a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising instructions for execution by a processor that cause the processor to:   obtain a response time feed value for a first middleware operating system to execute a first read-only query operation of a plurality of read-only query operations for execution against a database;   in response to determining that the response time feed value obtained for the first middleware operating system executing exceeds a time limit, identify each of a plurality of alternative middleware operating systems that are different from the first middleware operating system;   determine respective cost penalty amounts for executing the plurality of read-only query operations by the first middleware operating system and each of the alternative middleware operating systems exceeding the time limit, wherein the respective cost penalty amounts are based on service level agreement (SLA) penalty costs;   migrate execution of a second read-only query operation of the plurality of read-only query operations to a one of the alternative middleware operating systems that has a lowest total combined cost of licensing costs, computer processing hardware costs, and the respective cost penalty amounts.   
     
     
         16 . The computer program product of  claim 8 , wherein the first read-only query operation comprises an operation of an input structured query language (SQL) query task. 
     
     
         17 . The computer program product of  claim 8 , wherein the hardware costs comprise costs selected from a group consisting of: hardware equipment acquisition costs; hardware equipment power costs; hardware equipment maintenance costs; software costs; and differential labor costs. 
     
     
         18 . The computer program product of  claim 8 , wherein the licensing costs are selected from a group consisting of: site license costs; host license costs; instance license costs; and
 migration costs.   
     
     
         19 . The computer program product of  claim 8 , wherein the time limit comprises a response time percentile index value. 
     
     
         20 . The computer program product of  claim 19 , wherein the instructions are executable to determine a value of at least one of the cost penalty amounts in response to determining that a percentage of transaction response times for executing the plurality of read-only query operations exceeds the response time percentile index value during an execution time period.