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 |
|
Tracks Azure health using latest Azure Health API - more info @ https://docs.microsoft.com/en-us/rest/api/resourcehealth/availabilitystatuses/getbyresource/ | ||||||||||||||||
AzureAdvisorRecommendationMetric |
|
Tracks Azure recommendations using latest Azure Advisor API - more info @ https://docs.microsoft.com/en-us/rest/api/advisor/ | ||||||||||||||||
AzureElasticPoolDatabaseDetails |
|
Tracks details of all Databases for current Elastic Pool | ||||||||||||||||
AzureElasticPoolDetails |
|
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 |
Possible commands that can be executed on a given resource. Ultimate subscription is required.
Command Type | Description | |
---|---|---|
WebRequest | Runs custom WebRequest to specified URL |
CloudMonix provided default monitoring templates.
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 |
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 |