server_based_performance_tiers

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

Overview

Name	server_based_performance_tiers
Type	Resource
Id	azure.maria_db.server_based_performance_tiers

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
id	string	ID of the performance tier.
maxBackupRetentionDays	integer (int32)	Maximum Backup retention in days for the performance tier edition
maxLargeStorageMB	integer (int32)	Max storage allowed for a server.
maxStorageMB	integer (int32)	Max storage allowed for a server.
minBackupRetentionDays	integer (int32)	Minimum Backup retention in days for the performance tier edition
minLargeStorageMB	integer (int32)	Max storage allowed for a server.
minStorageMB	integer (int32)	Max storage allowed for a server.
serviceLevelObjectives	array	Service level objectives associated with the performance tier

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	subscriptionId, resourceGroupName, serverName		List all the performance tiers for a MariaDB server.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
resourceGroupName	string	The name of the resource group. The name is case insensitive.
serverName	string	The name of the server.
subscriptionId	string	The ID of the target subscription.

SELECT examples

list

List all the performance tiers for a MariaDB server.

SELECT
id,
maxBackupRetentionDays,
maxLargeStorageMB,
maxStorageMB,
minBackupRetentionDays,
minLargeStorageMB,
minStorageMB,
serviceLevelObjectives
FROM azure.maria_db.server_based_performance_tiers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
;