Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlInsightThresholds

Inventory details.

Properties

degradationInPct

degradationInPct: number

Degradation Percent Threshold is used to derive degrading SQLs. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

improvedInPct

improvedInPct: number

Improved Percent Threshold is used to derive improving SQLs. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

increaseInCPUInPct

increaseInCPUInPct: number

PctIncreaseInCPU is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in CPU Time beyond threshold. Insights are derived using linear regression. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

increaseInIOInPct

increaseInIOInPct: number

PctIncreaseInIO is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in IO Time beyond threshold. Insights are derived using linear regression. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

increaseInInefficientWaitInPct

increaseInInefficientWaitInPct: number

PctIncreaseInIO is used for deriving insights for SQLs which are degrading or variant or inefficient. And these SQLs should also have increasing change in Other Wait Time beyond threshold. Insights are derived using linear regression. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

inefficiencyInPct

inefficiencyInPct: number

Inefficiency Percent Threshold is used to derive inefficient SQLs. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

variability

variability: number

Variability Percent Threshold is used to derive variant SQLs. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

getJsonObj