SqlElasticPool Interface

public interface SqlElasticPool extends IndependentChildResource<SqlServerManager, ElasticPoolInner>,Refreshable,Updatable<SqlElasticPool.Update>,ExternalChildResource<SqlElasticPool, SqlServer>,HasInner,HasResourceGroup,Refreshable,Updatable<SqlElasticPool.Update>

An immutable client-side representation of an Azure SQL Elastic Pool.

An immutable client-side representation of an Azure SQL ElasticPool.

Method Summary

Modifier and Type Method and Description
SqlDatabase addExistingDatabase(SqlDatabase database)

Adds an existing SQL Database to the Elastic Pool.

SqlDatabase addExistingDatabase(String databaseName)

Adds an existing SQL Database to the Elastic Pool.

SqlDatabase addNewDatabase(String databaseName)

Adds a new SQL Database to the Elastic Pool.

DateTime creationDate()
int databaseDtuMax()
int databaseDtuMin()
void delete()

Deletes this SQL Elastic Pool from the parent SQL server.

Completable deleteAsync()

Deletes this SQL Elastic Pool asynchronously from the parent SQL server.

int dtu()
ElasticPoolEdition edition()
SqlDatabase getDatabase(String databaseName)

Gets the specific database in the elastic pool.

List<ElasticPoolActivity> listActivities()
Observable<ElasticPoolActivity> listActivitiesAsync()
List<ElasticPoolDatabaseActivity> listDatabaseActivities()
Observable<ElasticPoolDatabaseActivity> listDatabaseActivitiesAsync()
List<SqlDatabaseMetricDefinition> listDatabaseMetricDefinitions()

Lists the database metric definitions for this SQL Elastic Pool.

Observable<SqlDatabaseMetricDefinition> listDatabaseMetricDefinitionsAsync()

Asynchronously lists the database metric definitions for this SQL Elastic Pool.

List<SqlDatabaseMetric> listDatabaseMetrics(String filter)

Lists the database metrics for this SQL Elastic Pool.

Observable<SqlDatabaseMetric> listDatabaseMetricsAsync(String filter)

Asynchronously lists the database metrics for this SQL Elastic Pool.

List<SqlDatabase> listDatabases()

Lists the SQL databases in this SQL Elastic Pool.

Observable<SqlDatabase> listDatabasesAsync()

Asynchronously lists the SQL databases in this SQL Elastic Pool.

String parentId()
Region region()
String regionName()
SqlDatabase removeDatabase(String databaseName)

Removes an existing SQL Database from the Elastic Pool.

String sqlServerName()
ElasticPoolState state()
int storageCapacityInMB()
int storageMB()

Inherited Members

Method Details

addExistingDatabase

public SqlDatabase addExistingDatabase(SqlDatabase database)

Adds an existing SQL Database to the Elastic Pool.

Parameters:

database - the database to be added

Returns:

the database

addExistingDatabase

public SqlDatabase addExistingDatabase(String databaseName)

Adds an existing SQL Database to the Elastic Pool.

Parameters:

databaseName - name of the database

Returns:

the database

addNewDatabase

public SqlDatabase addNewDatabase(String databaseName)

Adds a new SQL Database to the Elastic Pool.

Parameters:

databaseName - name of the database

Returns:

the database

creationDate

public DateTime creationDate()

Returns:

the creation date of the Azure SQL Elastic Pool

databaseDtuMax

public int databaseDtuMax()

Returns:

the maximum DTU any one SQL Azure database can consume.

databaseDtuMin

public int databaseDtuMin()

Returns:

the minimum DTU all SQL Azure Databases are guaranteed

delete

public void delete()

Deletes this SQL Elastic Pool from the parent SQL server.

deleteAsync

public Completable deleteAsync()

Deletes this SQL Elastic Pool asynchronously from the parent SQL server.

Returns:

a representation of the deferred computation of this call

dtu

public int dtu()

Returns:

The total shared DTU for the SQL Azure Database Elastic Pool

edition

public ElasticPoolEdition edition()

Returns:

the edition of Azure SQL Elastic Pool

getDatabase

public SqlDatabase getDatabase(String databaseName)

Gets the specific database in the elastic pool.

Parameters:

databaseName - name of the database to look into

Returns:

the information about specific database in elastic pool

listActivities

public List listActivities()

Returns:

the information about elastic pool activities

listActivitiesAsync

public Observable listActivitiesAsync()

Returns:

a representation of the deferred computation of the information about elastic pool activities

listDatabaseActivities

public List listDatabaseActivities()

Returns:

the information about elastic pool database activities

listDatabaseActivitiesAsync

public Observable listDatabaseActivitiesAsync()

Returns:

the information about elastic pool database activities

listDatabaseMetricDefinitions

public List listDatabaseMetricDefinitions()

Lists the database metric definitions for this SQL Elastic Pool.

Returns:

the elastic pool's metric definitions

listDatabaseMetricDefinitionsAsync

public Observable listDatabaseMetricDefinitionsAsync()

Asynchronously lists the database metric definitions for this SQL Elastic Pool.

Returns:

a representation of the deferred computation of this call

listDatabaseMetrics

public List listDatabaseMetrics(String filter)

Lists the database metrics for this SQL Elastic Pool.

Parameters:

filter - an OData filter expression that describes a subset of metrics to return

Returns:

the elastic pool's database metrics

listDatabaseMetricsAsync

public Observable listDatabaseMetricsAsync(String filter)

Asynchronously lists the database metrics for this SQL Elastic Pool.

Parameters:

filter - an OData filter expression that describes a subset of metrics to return

Returns:

a representation of the deferred computation of this call

listDatabases

public List listDatabases()

Lists the SQL databases in this SQL Elastic Pool.

Returns:

the information about databases in elastic pool

listDatabasesAsync

public Observable listDatabasesAsync()

Asynchronously lists the SQL databases in this SQL Elastic Pool.

Returns:

a representation of the deferred computation of this call

parentId

public String parentId()

Returns:

the parent SQL server ID

region

public Region region()

Returns:

the region the resource is in

regionName

public String regionName()

Returns:

the name of the region the resource is in

removeDatabase

public SqlDatabase removeDatabase(String databaseName)

Removes an existing SQL Database from the Elastic Pool.

Parameters:

databaseName - name of the database

Returns:

the database

sqlServerName

public String sqlServerName()

Returns:

name of the SQL Server to which this elastic pool belongs

state

public ElasticPoolState state()

Returns:

the state of the Azure SQL Elastic Pool

storageCapacityInMB

public int storageCapacityInMB()

Returns:

the storage capacity limit for the SQL Azure Database Elastic Pool in MB

storageMB

public int storageMB()

Returns:

the storage limit for the SQL Azure Database Elastic Pool in MB

Applies to