Skip to main content

location_based_performance_tiers

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

Overview

Namelocation_based_performance_tiers
TypeResource
Idazure.maria_db.location_based_performance_tiers

Fields

NameDatatypeDescription
idstringID of the performance tier.
maxBackupRetentionDaysintegerMaximum Backup retention in days for the performance tier edition
maxLargeStorageMBintegerMax storage allowed for a server.
maxStorageMBintegerMax storage allowed for a server.
minBackupRetentionDaysintegerMinimum Backup retention in days for the performance tier edition
minLargeStorageMBintegerMax storage allowed for a server.
minStorageMBintegerMax storage allowed for a server.
serviceLevelObjectivesarrayService level objectives associated with the performance tier

Methods

NameAccessible byRequired ParamsDescription
listSELECTlocationName, subscriptionIdList all the performance tiers at specified location in a given subscription.

SELECT examples

List all the performance tiers at specified location in a given subscription.

SELECT
id,
maxBackupRetentionDays,
maxLargeStorageMB,
maxStorageMB,
minBackupRetentionDays,
minLargeStorageMB,
minStorageMB,
serviceLevelObjectives
FROM azure.maria_db.location_based_performance_tiers
WHERE locationName = '{{ locationName }}'
AND subscriptionId = '{{ subscriptionId }}';