Skip to main content

elastic_pools_metrics

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

Overview

Nameelastic_pools_metrics
TypeResource
Idazure.sql.elastic_pools_metrics

Fields

NameDatatypeDescription
nameobjectA database metric name.
endTimestringThe end time for the metric (ISO-8601 format).
metricValuesarrayThe metric values for the specified time window and timestep.
startTimestringThe start time for the metric (ISO-8601 format).
timeGrainstringThe time step to be used to summarize the metric values.
unitstringThe unit of the metric.

Methods

NameAccessible byRequired ParamsDescription
listSELECT$filter, elasticPoolName, resourceGroupName, serverName, subscriptionIdReturns elastic pool metrics.

SELECT examples

Returns elastic pool metrics.

SELECT
name,
endTime,
metricValues,
startTime,
timeGrain,
unit
FROM azure.sql.elastic_pools_metrics
WHERE $filter = '{{ $filter }}'
AND elasticPoolName = '{{ elasticPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';