Home
%3CLINGO-SUB%20id%3D%22lingo-sub-368885%22%20slang%3D%22en-US%22%3ESizing%20an%20Elastic%20Pool%20eDTU%20and%20Storage%20resources%20use%20Graphical%20runbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-368885%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20May%2004%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EThis%20runbook%20sizing%20an%20elastic%20pool%26nbsp%3Bset%20Maximum%20DTUs%20utilized%20by%20all%20databases%20in%20the%20pool%26nbsp%3B%26nbsp%3B.%20And%20set%20Maximum%20storage%20bytes%20utilized%20by%20all%20databases%20in%20the%20pool.%20You%20can%20look%20up%20the%20available%20characteristics%20and%20tiers%20on%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-elastic-pool%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-elastic-pool%3C%2FA%3E%20%3CSTRONG%3E%20%3C%2FSTRONG%3E%3C%2FP%3E%3CBR%20%2F%3E%20This%20runbook%20takes%20the%20following%20parameters%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20ResouceGroupName%3A%20The%20name%20of%20the%20resource%20group%20that%20the%20SQL%20server%20is%20part%20of.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20ServerName%3A%20The%20SQL%20server%20name.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20ElasticPoolName%3A%20Specifies%20the%20name%20of%20the%20elastic%20pool.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Dtu%3A%20Specifies%20the%20total%20number%20of%20shared%20DTUs%20for%20the%20elastic%20pool.%20The%20default%20values%20for%20different%20editions%20are%20as%20follows%3A%20-%20Basic.%20100%20DTUs%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20DatabaseDtuMin%3A%20Specifies%20the%20minimum%20number%20of%20DTUs%20that%20the%20elastic%20pool%20guarantees%20to%20all%20the%20databases%20in%20the%20pool.%20The%20default%20value%20is%20zero%20(0).%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20DatabaseDtuMax%3A%20Specifies%20the%20maximum%20number%20of%20DTUs%20that%20any%20single%20database%20in%20the%20pool%20can%20consume.%20The%20default%20values%20for%20different%20editions%20are%20as%20follows%3A%20-%20Basic.%205%20DTUs%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Edition%3A%20Specifies%20the%20edition%20of%20the%20Azure%20SQL%20Database%20for%20the%20elastic%20pool.%20You%20cannot%20change%20the%20edition.%20The%20acceptable%20values%20for%20this%20parameter%20are%3A-%20None%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20SubscriptionID%3A%20An%20optional%20subscription%20ID%20if%20you%20want%20to%20work%20against%20an%20Azure%20subscription.%20The%20default%20is%20subscription%20is%20selected%20if%20not%20set.%20%3CSTRONG%3E%20%3C%2FSTRONG%3E%20%3CEM%3E%20%3C%2FEM%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Download%20link%3A%20%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2Fscriptcenter%2FSizing-an-Elastic-Pool-c92d6ec4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fgallery.technet.microsoft.com%2Fscriptcenter%2FSizing-an-Elastic-Pool-c92d6ec4%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20How%20to%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fautomation%2Fautomation-creating-importing-runbook%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Creating%20or%20importing%20a%20runbook%20in%20Azure%20Automation%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20How%20to%20%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Fsystem-center-docs%2Fsma%2Fmanage%2Fscheduling-a-runbook%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20scheduling%20a%20runbook%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20id%3D%22172853%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F88924iD085996468B56851%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-368885%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20May%2004%2C%202017%20This%20runbook%20sizing%20an%20elastic%20pool%26nbsp%3Bset%20Maximum%20DTUs%20utilized%20by%20all%20databases%20in%20the%20pool%26nbsp%3B%26nbsp%3B.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-368885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eautomation%20account%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Automation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%20DB%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eedtu%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eelastic%20pool%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esizing%20elastic%20pool%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool


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: https://gallery.technet.microsoft.com/scriptcenter/Sizing-an-Elastic-Pool-c92d6ec4

How to Creating or importing a runbook in Azure Automation

How to scheduling a runbook