Azure SQL Data Warehouse

Available Metrics

Possible metric types that can be tracked on a given resource.

Metric Type Data Type Description
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
AzureAdvisorHealth
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
AzureOperation
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

Available Commands

Possible commands that can be executed on a given resource. Ultimate subscription is required.

Command Type Description
AzureSqlDbResize Resizes Azure SQL database
AzureSqlWarehousePause Pauses Azure Warehouse database
AzureSqlWarehouseResume Starts Azure Warehouse database
CustomSqlDatabaseScript Runs custom SQL script on specified database
WebRequest Runs custom WebRequest to specified URL

Default Templates

CloudMonix provided default monitoring templates.

Pre-configured Metrics

Metric Name Metric Type Description
ActiveLoadCount DatabaseSqlAzureWarehouseActiveLoadCount
ActiveRequestCount DatabaseSqlAzureWarehouseActiveRequestCount
ActiveRequests DatabaseSqlAzureWarehouseActiveRequests
DataIO DatabaseSqlAzureWarehouseUsage Tracks Data I/O utilization
DWU DatabaseSqlAzureWarehouseUsage
FailedConnectionCount DatabaseSqlAzureWarehouseUsage
IdleSessionCount DatabaseSqlAzureWarehouseIdleSessionCount
OpenConnections DatabaseSqlAzureWarehouseActiveConnections
QueuedLoadCount DatabaseSqlAzureWarehouseQueuedLoadCount
QueuedRequestCount DatabaseSqlAzureWarehouseQueuedRequestCount
QueuedRequests DatabaseSqlAzureWarehouseQueuedRequests
ResourceGovernorStats DatabaseSqlAzureWarehouseResourceGovernor
Size DatabaseSize Tracks the size of the monitored SQL Data Warehouse database
Status ResourceStatus Tracks the overall readiness status of the monitored resource. Possible values are: Ready, Down, Stopped and Unknown
SuccessfulConnectionCount DatabaseSqlAzureWarehouseUsage Tracks the number of successful connections
TopQueries DatabaseSqlAzureWarehouseTopQueries
TotalSessionCount DatabaseSqlAzureWarehouseTotalSessionCount

Pre-configured Alerts

Alert Name Expression Severity Description
Resource Outage Status == "Down" Error Raises an alert when connectivity cannot be established, after specified number of retries on the Advanced tab for sustained period of time