Skip to main content

elastic_pools_metric_definitions

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

Overview

Nameelastic_pools_metric_definitions
TypeResource
Idazure.sql.elastic_pools_metric_definitions

Fields

NameDatatypeDescription
nameobjectA database metric name.
metricAvailabilitiesarrayThe list of database metric availabilities for the metric.
primaryAggregationTypestringThe primary aggregation type defining how metric values are displayed.
resourceUristringThe resource uri of the database.
unitstringThe unit of the metric.

Methods

NameAccessible byRequired ParamsDescription
listSELECTelasticPoolName, resourceGroupName, serverName, subscriptionIdReturns elastic pool metric definitions.

SELECT examples

Returns elastic pool metric definitions.

SELECT
name,
metricAvailabilities,
primaryAggregationType,
resourceUri,
unit
FROM azure.sql.elastic_pools_metric_definitions
WHERE elasticPoolName = '{{ elasticPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';