title	description	author	manager	ms.assetid	ms.topic	ms.service	ms.devlang	ms.date	ms.author	ms.reviewer
Manage SQL database elastic pools with Java | Microsoft Docs	Sample code to create and configure Azure SQL databases using the Azure SDK for Java	rloutlaw	douge	9b461de8-46bc-4650-8e9e-59531f4e2a53	article	azure	java	3/30/2017	brendm	asirveda

Manage Azure SQL databases in elastic pools from your Java applications

This sample creates a SQL database server with an elastic pool to manage and scale resources for mulitple databases in a single plan.

Run the sample

Create an authentication file and set an environment variable AZURE_AUTH_LOCATION with the full path to the file on your computer. Then run:

git clone https://github.com/Azure-Samples/sql-database-java-manage-sql-dbs-in-elastic-pool
cd sql-database-java-manage-sql-dbs-in-elastic-pool
mvn clean compile exec:java

View the complete code sample on GitHub

Authenticate with Azure

[!INCLUDE auth-include]

Create a SQL database server with an elastic pool

SqlServer sqlServer = azure.sqlServers().define(sqlServerName)
                    .withRegion(Region.US_EAST)
                    .withNewResourceGroup(rgName)
                    .withAdministratorLogin(administratorLogin)
                    .withAdministratorPassword(administratorPassword)
                    // Use ElasticPoolEditions.STANDARD as the edition
                    // and create two databases
                    .withNewElasticPool(elasticPoolName, ElasticPoolEditions.STANDARD, 
                        database1Name, database2Name)
                    .create();

See the ElasticPoolEditions class reference for current edition values. Review the SQL database elastic pool documentation to compare edition resource characteristics.

Change Database Transaction Unit (DTU) settings in an elastic pool

// Set an pool of 200 eDTUs to share between the databases
// and ensure that a database always has 10 DTUs available but never uses more than 50
elasticPool = elasticPool.update()
                    .withDtu(200)
                    .withDatabaseDtuMin(10)
                    .withDatabaseDtuMax(50)
                    .apply();

Review the DTUs and eDTUs documentation to learn more about allocating resources to SQL databases.

Create a new database and add it to an elastic pool

// Add a newly created database to the elastic pool
SqlDatabase anotherDatabase = sqlServer.databases().define(anotherDatabaseName).create();
elasticPool.update().withExistingDatabase(anotherDatabase).apply();            

The API creates anotherDatabase at S0 tier in the first statement. Moving anotherDatabase to the elastic pool assigns the database resources based on the pool settings.

Remove a database from an elastic pool

// Assign an edition since the database resources are no longer managed in the pool 
anotherDatabase = anotherDatabase.update()
                     .withoutElasticPool()
                     .withEdition(DatabaseEditions.STANDARD)
                     .apply();

See the DatabaseEditions class reference for values to pass to withEdition().

List current database activities in an elastic pool

// get a list of in-flight elastic operations on databases in the pool and log them 
for (ElasticPoolDatabaseActivity databaseActivity : elasticPool.listDatabaseActivities()) {
    System.out.println("Database " + databaseActivity.databaseName() 
        + " performing operation " + databaseActivity.operation() + 
        " with objective " + databaseActivity.requestedServiceObjective());
}

Database activities include moving a database in or out of an elastic pool and updating databases in an elastic pool.

List databases in an elastic pool

// Log a list of databases in the elastic pool 
for (SqlDatabase databaseInServer : elasticPool.listDatabases()) {
    System.out.println(databaseInServer.name());
}

Review the methods in com.microsoft.azure.management.sql.SqlDatabase to query the databases in more detail.

Delete an elastic pool

sqlServer.elasticPools().delete(elasticPoolName);

The elastic pool must be empty before deleting it.

Sample code summary.

The sample creates a SQL server with two databases managed in a single elasic pool. The elastic pool resource limits are updated, then additional databases are added to the pool. The code then reads the elastic pool's configuration and state.

The sample deletes all resources it created before exiting.

Class used in sample	Notes
SqlServer	SQL DB server in Azure created by azure.sqlServers().define()...create() fluent chain. Provides methods to create and work with elastic pools and databases.
SqlDatabase	Client side object representing a SQL database. Created through sqlServer().define()...create().
DatabaseEditions	Constant static fields used to set database resources when creating a database outside of an elastic pool or when moving a database out of an elastic pool
SqlElasticPool	Created from the withNewElasticPool() section of the fluent chain that created the SqlServer in Azure. Provides methods to set resource limits for databases running in the elastic pool and for the elastic pool itself.
ElasticPoolEditions	Class of constant fields defining the resources available to an elastic pool. See SQL database elastic pool documentation for tier details.
ElasticPoolDatabaseActivity	Retreived from SqlElasticPool.listDatabaseActivities(). Each object of this type represents an activity performed on a database in the elastic pool.
ElasticPoolActivity	Retrieved in a List from SqlElasticPool.listActivities(). Each of object in the list represents an activity performed on the elastic pool (not the databases in the elastic pool).

Next steps

[!INCLUDE next-steps]