class Azure::SQL::Mgmt::V2014_04_01::Models::TopQueries

A database query.

Attributes

aggregation_function[RW]

@return [QueryAggregationFunction] The function that is used to aggregate each query's metrics. Possible values include: 'min', 'max', 'avg', 'sum'

execution_type[RW]

@return [QueryExecutionType] The execution type that is used to filter the query instances that are returned. Possible values include: 'any', 'regular', 'irregular', 'aborted', 'exception'

interval_type[RW]

@return [String] The duration of the interval (ISO8601 duration format).

number_of_top_queries[RW]

@return [Float] The number of requested queries.

observation_end_time[RW]

@return [DateTime] The end time for queries that are returned (ISO8601 format)

observation_start_time[RW]

@return [DateTime] The start time for queries that are returned (ISO8601 format)

observed_metric[RW]

@return [QueryObservedMetricType] The type of metric to use for ordering the top metrics. Possible values include: 'cpu', 'io', 'logio', 'duration', 'executionCount'

queries[RW]

@return [Array<QueryStatistic>] The list of queries.

Private Class Methods

mapper() click to toggle source

Mapper for TopQueries class as Ruby Hash. This will be used for serialization/deserialization.

# File lib/2014-04-01/generated/azure_mgmt_sql/models/top_queries.rb, line 53
def self.mapper()
  {
    client_side_validation: true,
    required: false,
    serialized_name: 'TopQueries',
    type: {
      name: 'Composite',
      class_name: 'TopQueries',
      model_properties: {
        aggregation_function: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'aggregationFunction',
          type: {
            name: 'Enum',
            module: 'QueryAggregationFunction'
          }
        },
        execution_type: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'executionType',
          type: {
            name: 'Enum',
            module: 'QueryExecutionType'
          }
        },
        interval_type: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'intervalType',
          type: {
            name: 'String'
          }
        },
        number_of_top_queries: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'numberOfTopQueries',
          type: {
            name: 'Double'
          }
        },
        observation_start_time: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'observationStartTime',
          type: {
            name: 'DateTime'
          }
        },
        observation_end_time: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'observationEndTime',
          type: {
            name: 'DateTime'
          }
        },
        observed_metric: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'observedMetric',
          type: {
            name: 'Enum',
            module: 'QueryObservedMetricType'
          }
        },
        queries: {
          client_side_validation: true,
          required: false,
          read_only: true,
          serialized_name: 'queries',
          type: {
            name: 'Sequence',
            element: {
                client_side_validation: true,
                required: false,
                serialized_name: 'QueryStatisticElementType',
                type: {
                  name: 'Composite',
                  class_name: 'QueryStatistic'
                }
            }
          }
        }
      }
    }
  }
end