AggregatedMetric
|
Object
|
Allows for aggregating existing metrics over a period of time. Useful for running sums or averages; also for extracting single data item from collection-based metrics
|
AzureAdvisorHealthMetric
|
AvailabilityState
|
String
|
Summary
|
String
|
ReasonType
|
String
|
ReasonChronicity
|
String
|
DetailedStatus
|
String
|
OccuredTime
|
DateTime
|
ReportedTime
|
DateTime
|
|
Tracks Azure health using latest Azure Health API - more info @ https://docs.microsoft.com/en-us/rest/api/resourcehealth/availabilitystatuses/getbyresource/
|
AzureAdvisorRecommendationMetric
|
AzureAdvisorRecommendation[]
Category
|
String
|
Impact
|
String
|
LastUpdated
|
Nullable`1
|
Risk
|
String
|
Problem
|
String
|
Solution
|
String
|
|
Tracks Azure recommendations using latest Azure Advisor API - more info @ https://docs.microsoft.com/en-us/rest/api/advisor/
|
AzureMonitorMetric
|
Double
|
Tracks Azure metrics using latest Azure Monitor API - more info @ https://docs.microsoft.com/en-us/rest/api/monitor/
|
DatabaseSize
|
Double
|
Tracks the size of the database in megabytes.
|
DatabaseSqlAzureDtu
|
Double
|
Tracks overall DTU % utilization of the monitored database. Calculated as the maximum value between DatabaseSqlAzureResourceStatsCpuUtilization, DatabaseSqlAzureResourceStatsDataIOUtilization, and DatabaseSqlAzureResourceStatsLogWriteUtilization.
|
DatabaseSqlAzurePricingTier
|
AzureSqlDatabasePricingTier
Edition
|
String
|
PricingTier
|
String
|
|
Tracks the database edition and service tier.
|
DatabaseSqlAzureResourceStatsCpuUtilization
|
Double
|
Tracks overall CPU % utilization of the monitored database.
|
DatabaseSqlAzureResourceStatsDataIOUtilization
|
Double
|
Tracks overall Data I/O % utilization of the monitored database.
|
DatabaseSqlAzureResourceStatsLogWriteUtilization
|
Double
|
Tracks the overall Log Write % utilization of the monitored database.
|
DatabaseSqlAzureWarehouseActiveConnections
|
SqlAzureWarehouseConnection[]
SessionId
|
String
|
RequestId
|
String
|
Status
|
String
|
SecurityId
|
String
|
Login
|
String
|
LoginTime
|
DateTime
|
QueryCount
|
Int32
|
ClientId
|
String
|
Application
|
String
|
|
Tracks a list of currently open connections. Information retrieved from sys.dm_pdw_sys_info view
|
DatabaseSqlAzureWarehouseActiveLoadCount
|
Int32
|
Tracks count of active loads. Information retrieved from sys.dm_pdw_sys_info view
|
DatabaseSqlAzureWarehouseActiveRequestCount
|
Int32
|
Tracks idle session count. Information retrieved from sys.dm_pdw_sys_info view
|
DatabaseSqlAzureWarehouseActiveRequests
|
SqlAzureWarehouseRequest[]
RequestId
|
String
|
SessionId
|
String
|
Status
|
String
|
StartTime
|
DateTime
|
EndTime
|
DateTime
|
ElapsedTimeMsec
|
Int32
|
Label
|
String
|
ErrorId
|
String
|
Command
|
String
|
|
Tracks a list of currently executing requests (up to 100 records). Information retrieved from sys.dm_pdw_exec_requests view
|
DatabaseSqlAzureWarehouseIdleSessionCount
|
Int32
|
Tracks idle session count. Information retrieved from sys.dm_pdw_sys_info view
|
DatabaseSqlAzureWarehouseOperations
|
Name
|
String
|
Category
|
String
|
Description
|
String
|
Caller
|
String
|
EventName
|
String
|
Level
|
String
|
Status
|
String
|
SubStatus
|
String
|
ExtendedInfo
|
String
|
EventTimestamp
|
DateTime
|
|
Tracks the log of Azure management operations on the monitored resource.
|
DatabaseSqlAzureWarehouseQueuedLoadCount
|
Int32
|
Tracks count of queued up loads. Information retrieved from sys.dm_pdw_sys_info view
|
DatabaseSqlAzureWarehouseQueuedRequestCount
|
Int32
|
Tracks queued request count. Information retrieved from sys.dm_pdw_sys_info view
|
DatabaseSqlAzureWarehouseQueuedRequests
|
SqlAzureWarehouseRequest[]
RequestId
|
String
|
SessionId
|
String
|
Status
|
String
|
StartTime
|
DateTime
|
EndTime
|
DateTime
|
ElapsedTimeMsec
|
Int32
|
Label
|
String
|
ErrorId
|
String
|
Command
|
String
|
|
Tracks a list of currently executing requests. Information retrieved from sys.dm_pdw_exec_requests view
|
DatabaseSqlAzureWarehouseResourceGovernor
|
SqlAzureWarehouseResourceGovernor[]
Pool
|
String
|
PoolMaxMemoryMB
|
Double
|
Group
|
String
|
GroupImportance
|
String
|
MaxMemoryGrantedMB
|
Double
|
Node
|
String
|
NodeType
|
String
|
TotalRequests
|
Int64
|
TotalQueuedRequests
|
Int64
|
ActiveRequests
|
Int64
|
ActiveQueuedRequests
|
Int64
|
|
Tracks a list of of the differences in memory resource allocation in detail from the perspective of the resource governor. More info: https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-develop-concurrency/
|
DatabaseSqlAzureWarehouseTopQueries
|
SqlAzureWarehouseRequest[]
RequestId
|
String
|
SessionId
|
String
|
Status
|
String
|
StartTime
|
DateTime
|
EndTime
|
DateTime
|
ElapsedTimeMsec
|
Int32
|
Label
|
String
|
ErrorId
|
String
|
Command
|
String
|
|
Tracks a list of longest executing requests over the last hour. Information retrieved from sys.dm_pdw_exec_requests view
|
DatabaseSqlAzureWarehouseTotalSessionCount
|
Int32
|
Tracks total session count. Information retrieved from sys.dm_pdw_sys_info view
|
DatabaseSqlAzureWarehouseUsage
|
Double
|
Tracks performance-related metrics exposed by Azure ARM API for given Warehouse database. WARNING: currently, values for these metrics are unreliable as Azure API is frequently delayed
|
DatabaseSqlNumeric
|
Double
|
Tracks numeric value from custom user-defined SQL statement.
|
DatabaseSqlQuery
|
Object[]
|
Tracks a table-based collection of data retrieved via user-defined SQL statement.
|
DerivedMetric
|
Double
|
Allows for deriving new metrics from existing ones. Useful for combining existing metrics together or for multiplying metrics by a factor
|
LinkedMetric
|
Object
|
Allows for tracking of metrics from other resources. Useful when it is important to evaluate metrics from different resources side-by-side
|
ResourceInstanceCount
|
Int32
|
Tracks current number of compute instances
|
ResourceStatus
|
String
|
Tracks overall status of the resource. This is an important metric as it is used to drive Uptime reports. Possible values: Ready, Down, Unknown and in some cases Stopped
|
ResponseTime
|
Double
|
Measures time to connect to resource
|