Eksportér (0) Udskriv
Udvid alt
Expand Minimize
EN
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

sys.resource_stats

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

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 CPU usage and storage data for the database in five minute intervals. Historical data is retained for 14 days.

For each user database, there is one row for every five-minute reporting window where there is change in resource consumption. This includes CPU usage, storage size change or database SKU modification.

Idle databases with no changes may not have rows for every five minutes.

 

Columns Data Type Description

start_time

datetime2

UTC time indicating the start of the 5 minute reporting interval. The value is always in multiples of 5 minutes, for example ‘2011-04-19 23:00:00’, ‘2011-04-19 23:05:00’.

end_time

datetime2

UTC time indicates the end of the 5 minute reporting interval. The value is always exactly 5 minutes more than the corresponding start_time value in the same row.

database_name

nvarchar

Name of user database.

sku

nvarchar

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

  • Web

  • Business

usage_in_seconds

int

CPU time used since the last measurement was taken.

storage_in_megabytes

decimal

Maximum storage size for the time period, 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.

Fællesskabsindhold

Tilføj
Vis:
© 2014 Microsoft