Azure SQL Elastic Pool

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/
AzureElasticPoolDatabaseDetails
AzureElasticPoolDatabase[]
Database String
Status String
Edition String
EarliestRestoreDate Nullable`1
DatabaseSize Nullable`1
CpuTimeInMs Nullable`1
BufferPages Nullable`1
BufferMBs Nullable`1
Tracks details of all Databases for current Elastic Pool
AzureElasticPoolDetails
AzureElasticPool
Name String
Location String
State String
Edition String
Dtu Nullable`1
DatabaseDtuMax Nullable`1
DatabaseDtuMin Nullable`1
StorageMb Nullable`1
Tracks details of current Elastic Pool
AzureMonitorMetric
Double
Tracks Azure metrics using latest Azure Monitor API - more info @ https://docs.microsoft.com/en-us/rest/api/monitor/
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

Available Commands

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

Command Type Description
WebRequest Runs custom WebRequest to specified URL

Default Templates

CloudMonix provided default monitoring templates.

Pre-configured Metrics

Metric Name Metric Type Description
CpuPercent AzureMonitorMetric Tracks "CPU percentage" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
Databases AzureElasticPoolDatabaseDetails Tracks database details inside the specified Elastic Pool
DataIOPercent AzureMonitorMetric Tracks "Data IO percentage" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
DtuPercent AzureMonitorMetric Tracks "DTU percentage" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
DtuUsed AzureMonitorMetric Tracks "eDTU used" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
InMemoryOLTPPercent AzureMonitorMetric Tracks "In-Memory OLTP storage percent" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
LogIOPercent AzureMonitorMetric Tracks "Log IO percentage" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
RecommendedActions AzureAdvisorRecommendationMetric Tracks recommended actions for specified resource.
SessionsPercent AzureMonitorMetric Tracks "Sessions percentage" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
Status ResourceStatus Tracks the overall readiness status of the monitored resource. Possible values are: Ready, Down, Stopped and Unknown
StoragePercent AzureMonitorMetric Tracks "Storage percentage" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
StorageUsed AzureMonitorMetric Tracks "Storage used" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools
WorkersPercent AzureMonitorMetric Tracks "Workers percentage" metric. For more detail visit the page https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics#microsoftsqlserverselasticpools

Pre-configured Alerts

Alert Name Expression Severity Description
Database Outage Any(Databases, "Status != \"Online\"") Warning Raises an alert when database status is not 'Online'
Database Size Any(Databases, "(Edition == \"Basic\" && DatabaseSize > 1600) || DatabaseSize > 800000") Warning
High CPU Percent CpuPercent > 80 Warning Raises an alert when CPU utilization is over 80% for the last 5 minutes sustained
High Data IO Percent DataIOPercent > 80 Warning Raises an alert when Data IO utilization is over 80% for the last 5 minutes sustained
High DTU Percent DtuPercent > 80 Warning Raises an alert when DTU utilization is over 70% for the last 5 minutes sustained
High In-Memory OLTP Storage Percent InMemoryOLTPPercent > 80 Warning Raises an alert when In-Memory OLTP Storage utilization is over 80% for the last 5 minutes sustained
High Sessions Percent SessionsPercent > 80 Warning Raises an alert when Session utilization is over 80% for the last 5 minutes sustained
High Storage Percent StoragePercent > 80 Warning Raises an alert when Storage utilization is over 80% for the last 5 minutes sustained
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