| title | sys.database_usage (Azure SQL Database) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom |
|
||||
| ms.date | 03/03/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.service | sql-database | ||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | be6820de-60bf-4ddd-ace7-4077893d630f | ||||
| caps.latest.revision | 13 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-xxxxxx-asdb-xxxx-xxx_md]
Note: This applies only to Azure SQL Database V11.
Lists the number, type, and duration of databases on the [!INCLUDEssSDS] 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. |
Read-only access to this view is available to all users with permissions to connect to the master database.
The sys.database_usage view returns one row for each day of your subscription.
SQL Database Pricing Details
Accounts and Billing in Windows Azure SQL Database