sys.database_usage (Azure SQL Database)

THIS TOPIC APPLIES TO: noSQL Server yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Note: This applies only to Azure SQL Database V11.

Lists the number, type, and duration of databases on the SQL Database server.

The sys.database_usage view contains the following columns.

Column Name Description
time The date when the usage events occurred.
sku The type of service tier for the database: Web, Business, Basic, Standard, Premium
quantity The maximum number of databases of an SKU type that existed during that day.

Permissions

Read-only access to this view is available to all users with permissions to connect to the master database.

Remarks

The sys.database_usage view returns one row for each day of your subscription.

See Also

SQL Database Pricing Details
Accounts and Billing in Windows Azure SQL Database