Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

sys.database_usage (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see sys.database_usage.

Lists the number, type, and duration of databases on the Microsoft SQL Database server. The sys.database_usage view is specific to Windows Azure SQL Database and is not supported in on-premise SQL Server.

The sys.database_usage view contains the following fields:

 

Column Name Description

time

The date when the usage events occurred.

sku

The type of database, either Business for the Business Edition or Web for the Web Edition.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.