Class AzureSQLDatabaseSchema.DatabaseServiceObjective

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.database_service_objectives (Azure SQL Database)

Applies to: √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics

Returns the edition (service tier), service objective (pricing tier) and elastic pool name, if any, for an Azure SQL database or an Azure Synapse Analytics. If logged on to the master database in an Azure SQL Database server, returns information on all databases. For Azure Synapse Analytics, you must be connected to the master database.

For information on pricing, see SQL Database options and performance: SQL Database Pricing and Azure Synapse Analytics Pricing.
To change the service settings, see ALTER DATABASE (Azure SQL Database) and ALTER DATABASE (Azure Synapse Analytics).
The sys.database_service_objectives view contains the following columns.

See sys.database_service_objectives.

[Table(Schema = "sys", Name = "database_service_objectives", IsView = true)]
public class AzureSQLDatabaseSchema.DatabaseServiceObjective

Inheritance

object

AzureSQLDatabaseSchema.DatabaseServiceObjective

Extension Methods

Map.DeepCopy<T>(T)

Properties

DatabaseID

The ID of the database, unique within an instance of Azure SQL Database server. Joinable with sys.databases (Transact-SQL).

[Column("database_id")]
[NotNull]
public int DatabaseID { get; set; }

Property Value

int

Edition

The service tier for the database or data warehouse: Basic, Standard, Premium or Data Warehouse.

[Column("edition")]
[NotNull]
public string Edition { get; set; }

Property Value

string

ElasticPoolName

The name of the elastic pool that the database belongs to. Returns NULL if the database is a single database or a data warehouse.

[Column("elastic_pool_name")]
[NotNull]
public string ElasticPoolName { get; set; }

Property Value

string

ServiceObjective

The pricing tier of the database. If the database is in an elastic pool, returns ElasticPool.

On the Basic tier, returns Basic.

Single database in a standard service tier returns one of the following: S0, S1, S2, S3, S4, S6, S7, S9 or S12.

Single database in a premium tier returns of the following: P1, P2, P4, P6, P11 or P15.

Azure Synapse Analytics returns DW100 through DW30000c.

For details, see single databases, elastic pools, data warehouses

[Column("service_objective")]
[NotNull]
public string ServiceObjective { get; set; }

Property Value

string