Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlInsightAggregation

Represents a SQL Insight.

Properties

category

category: string

Insight category. It would be one of the following DEGRADING, VARIANT, INEFFICIENT, CHANGING_PLANS, IMPROVING, DEGRADING_VARIANT, DEGRADING_INEFFICIENT, DEGRADING_CHANGING_PLANS, DEGRADING_INCREASING_IO, DEGRADING_INCREASING_CPU, DEGRADING_INCREASING_INEFFICIENT_WAIT, DEGRADING_CHANGING_PLANS_AND_INCREASING_IO, DEGRADING_CHANGING_PLANS_AND_INCREASING_CPU, DEGRADING_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT,VARIANT_INEFFICIENT, VARIANT_CHANGING_PLANS, VARIANT_INCREASING_IO, VARIANT_INCREASING_CPU, VARIANT_INCREASING_INEFFICIENT_WAIT, VARIANT_CHANGING_PLANS_AND_INCREASING_IO, VARIANT_CHANGING_PLANS_AND_INCREASING_CPU, VARIANT_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT, INEFFICIENT_CHANGING_PLANS, INEFFICIENT_INCREASING_INEFFICIENT_WAIT, INEFFICIENT_CHANGING_PLANS_AND_INCREASING_INEFFICIENT_WAIT

text

text: string

Insight text. For example {@code Degrading SQLs}, {@code Variant SQLs}, {@code Inefficient SQLs}, {@code Improving SQLs}, {@code SQLs with Plan Changes}, {@code Degrading SQLs have increasing IO Time above 50%}, {@code Degrading SQLs are variant}, {@code 2 of the 2 variant SQLs have plan changes}, Inefficient SQLs have increasing CPU Time above 50%

values

values: Array<number>

SQL counts for a given insight. For example insight text {@code 2 of 10 SQLs have degrading response time} will have values as [2,10]"

Functions

getDeserializedJsonObj

getJsonObj