KöpBuy
1-855-856-7678
SupportSupport
EN
Det här innehållet finns inte tillgängligt på ditt språk men här finns den engelska versionen,
sys.resource_stats
 Important |
|---|
This feature is in a preview state. Do not take a dependency on the specific implementation of this feature because the feature might be changed or removed in a future release.
While in a preview state, the Windows Azure SQL Database operations team might turn data collection off and on for this DMV:
|
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:
|
|
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.
