SALES: 1-800-867-1380
Expand Minimize

sys.resource_usage

Updated: April 2, 2011

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.resource_usage.

ImportantImportant
While in a preview state, the Microsoft Azure SQL Database operations team might turn data collection off and on for this DMV:

  • When turned on, the DMV returns current data as it is aggregated.

  • When turned off, the DMV returns historical data, which might be stale.

Provides hourly summary of resource usage data for user databases in the current server. Historical data is retained for 90 days.

For each user database, there is one row for every hour in continuous fashion. Even if the database was idle during that hour, there is one row, and the usage_in_seconds value for that database will be 0. Storage usage and SKU information is rolled up for the hour appropriately.

 

Columns Data Type Description

time

datetime

Time (UTC) in hour increments.

database_name

nvarchar

Name of user database.

sku

nvarchar

Name of the SKU. The following are the possible values:

  • Web

  • Business

If the database switched between Web and Business SKUs during the hour, the system records Business SKU.

usage_in_seconds

int

Sum of CPU time used in the hour.

storage_in_megabytes

decimal

Maximum storage size for the hour, including database data, indexes, stored procedures and metadata.

This view is available to all user roles with permissions to connect to the virtual master database.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft