managed_instances_by_managed_instances

Creates, updates, deletes, gets or lists a managed_instances_by_managed_instances resource.

Overview

Name	managed_instances_by_managed_instances
Type	Resource
Id	azure.sql.managed_instances_by_managed_instances

Fields

Name	Datatype	Description
aggregationFunction	string	Aggregation function used to calculate query metrics.
endTime	string	The end time for the metric (ISO-8601 format).
intervalType	string	Interval type (length).
numberOfQueries	integer	Requested number of top queries.
observationMetric	string	Metric used to rank queries.
queries	array	List of top resource consuming queries with appropriate metric data
startTime	string	The start time for the metric (ISO-8601 format).

Methods

Name	Accessible by	Required Params	Description
list	SELECT	managedInstanceName, resourceGroupName, subscriptionId	Get top resource consuming queries of a managed instance.

SELECT examples

Get top resource consuming queries of a managed instance.

SELECT
aggregationFunction,
endTime,
intervalType,
numberOfQueries,
observationMetric,
queries,
startTime
FROM azure.sql.managed_instances_by_managed_instances
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';