Class SqlInsightThresholds.Builder

    • Constructor Detail

      • Builder

        public Builder()
    • Method Detail

      • degradationInPct

        public SqlInsightThresholds.Builder degradationInPct​(Integer degradationInPct)
        Degradation Percent Threshold is used to derive degrading SQLs.
        Parameters:
        degradationInPct - the value to set
        Returns:
        this builder
      • variability

        public SqlInsightThresholds.Builder variability​(Float variability)
        Variability Percent Threshold is used to derive variant SQLs.
        Parameters:
        variability - the value to set
        Returns:
        this builder
      • inefficiencyInPct

        public SqlInsightThresholds.Builder inefficiencyInPct​(Integer inefficiencyInPct)
        Inefficiency Percent Threshold is used to derive inefficient SQLs.
        Parameters:
        inefficiencyInPct - the value to set
        Returns:
        this builder
      • increaseInIOInPct

        public SqlInsightThresholds.Builder increaseInIOInPct​(Integer increaseInIOInPct)
        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.

        Parameters:
        increaseInIOInPct - the value to set
        Returns:
        this builder
      • increaseInCPUInPct

        public SqlInsightThresholds.Builder increaseInCPUInPct​(Integer increaseInCPUInPct)
        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.

        Parameters:
        increaseInCPUInPct - the value to set
        Returns:
        this builder
      • increaseInInefficientWaitInPct

        public SqlInsightThresholds.Builder increaseInInefficientWaitInPct​(Integer increaseInInefficientWaitInPct)
        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.

        Parameters:
        increaseInInefficientWaitInPct - the value to set
        Returns:
        this builder
      • improvedInPct

        public SqlInsightThresholds.Builder improvedInPct​(Integer improvedInPct)
        Improved Percent Threshold is used to derive improving SQLs.
        Parameters:
        improvedInPct - the value to set
        Returns:
        this builder