Patent ID: 8219537

Claim:
A method for electronically identifying an unacceptably skewed query, the method comprising: electronically extracting query data from a computer log; using the query data, determining, using a processor, whether the query is unacceptably skewed; and marking an unacceptably skewed query as a candidate for tuning; wherein: the determining whether a query is unacceptably skewed comprises: calculating an actual skew for the query; calculating a maximum acceptable skew for the query; comparing the actual skew to the maximum acceptable skew; and identifying a query as unacceptably skewed if the actual skew exceeds the maximum acceptable skew; the calculating a maximum acceptable skew comprises calculating a maximum acceptable CPU skew based on the CPU processing time for the query; the calculating a maximum acceptable CPU skew comprises using the formula ACCTSKEW CPU = 56 O × N × LR + O + cosh ⁡ ( log ⁡ ( N × UR × O ) ) 55 ⁢ exp ⁡ ( log ⁡ ( O ) ) O + N 20 ; ACCTSKEW CPU corresponds to the maximum acceptable CPU skew; T corresponds to the total CPU processing time for all processors for the query, ranges from 0 to a maximum value, and has three sub-ranges: a mid-range, an upper range, and a lower range; MR is a constant that scales the acceptable skew corresponding to the mid-range; UR is a constant that scales the acceptable skew corresponding to the upper range; and LR is a constant that scales the acceptable skew corresponding to the lower range.