databases_metrics

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

Overview

Name	databases_metrics
Type	Resource
Id	azure.sql.databases_metrics

Fields

Name	Datatype	Description
name	object	A database metric name.
endTime	string	The end time for the metric (ISO-8601 format).
metricValues	array	The metric values for the specified time window and timestep.
startTime	string	The start time for the metric (ISO-8601 format).
timeGrain	string	The time step to be used to summarize the metric values.
unit	string	The unit of the metric.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	$filter, databaseName, resourceGroupName, serverName, subscriptionId	Returns database metrics.

SELECT examples

Returns database metrics.

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