Sizing an Elastic Pool eDTU and Storage resources use Graphical runbook

Published Mar 13 2019 06:41 PM 729 Views
First published on MSDN on May 04, 2017

This runbook sizing an elastic pool set Maximum DTUs utilized by all databases in the pool  . And set Maximum storage bytes utilized by all databases in the pool. You can look up the available characteristics and tiers on

This runbook takes the following parameters:

ResouceGroupName: The name of the resource group that the SQL server is part of.

ServerName: The SQL server name.

ElasticPoolName: Specifies the name of the elastic pool.

Dtu: Specifies the total number of shared DTUs for the elastic pool. The default values for different editions are as follows: - Basic. 100 DTUs

DatabaseDtuMin: Specifies the minimum number of DTUs that the elastic pool guarantees to all the databases in the pool. The default value is zero (0).

DatabaseDtuMax: Specifies the maximum number of DTUs that any single database in the pool can consume. The default values for different editions are as follows: - Basic. 5 DTUs

Edition: Specifies the edition of the Azure SQL Database for the elastic pool. You cannot change the edition. The acceptable values for this parameter are:- None

SubscriptionID: An optional subscription ID if you want to work against an Azure subscription. The default is subscription is selected if not set.

Download link:

How to Creating or importing a runbook in Azure Automation

How to scheduling a runbook

Version history
Last update:
‎Mar 13 2019 06:41 PM
Updated by: