usages_by_instance_pools

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

Overview

Name	usages_by_instance_pools
Type	Resource
Id	azure.sql.usages_by_instance_pools

Fields

Name	Datatype	Description
id	string	Resource ID.
name	object	ARM Usage Name
currentValue	integer	Usage current value.
limit	integer	Usage limit.
requestedLimit	integer	Usage requested limit.
type	string	Resource type.
unit	string	Usage unit.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	instancePoolName, resourceGroupName, subscriptionId	Gets all instance pool usage metrics

SELECT examples

Gets all instance pool usage metrics

SELECT
id,
name,
currentValue,
limit,
requestedLimit,
type,
unit
FROM azure.sql.usages_by_instance_pools
WHERE instancePoolName = '{{ instancePoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';