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 | ||||||||||||||||||
AmazonCloudWatchMetric |
Double
|
Tracks Amazon CloudWatch metrics using latest AWS API - more info is here. | ||||||||||||||||||
DatabaseActiveSessionCount |
Double
|
Tracks the number of open sessions for the given database. | ||||||||||||||||||
DatabaseMySqlQueries |
Double
|
Tracks the number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored procedures. | ||||||||||||||||||
DatabaseMySqlQueryErrors |
Double
|
Tracks count of queries executed with error. | ||||||||||||||||||
DatabaseMySqlQueryRunTime |
Double
|
Average run time for queries in microseconds. Available for MySQL versions 5.6.6 or higher. | ||||||||||||||||||
DatabaseMySqlReads |
Double
|
Tracks the number of SELECT statements. | ||||||||||||||||||
DatabaseMySqlTopQueries |
|
Tracks top 10 longest running queries. Query text display is limited to 2000 characters. | ||||||||||||||||||
DatabaseMySqlUtilization |
Double
|
Tracks various database statistics such as number of connections, performance metrics, etc. | ||||||||||||||||||
DatabaseMySqlWrites |
Double
|
Tracks the number of INSERT, UPDATE and DELETE statements. | ||||||||||||||||||
DatabaseSize |
Double
|
Tracks the size of the database in megabytes. | ||||||||||||||||||
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 | ||||||||||||||||||
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 |
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 |
---|---|---|
ConnectionsActive | DatabaseActiveSessionCount | Tracks number of open connections to the database |
Cpu | AmazonCloudWatchMetric | Average value of CPU utilization for the monitored MySQL Amazon database |
ErrorsCount | DatabaseMySqlQueryErrors | Count of executed queries with error |
QueriesCount | DatabaseMySqlQueries | Count of executed statements (sent by client) |
QueryRunTime | DatabaseMySqlQueryRunTime | Average run time for queries in microseconds |
ReadIOPS | AmazonCloudWatchMetric | Tracks Read IOPS of current database instance |
ReadsCount | DatabaseMySqlReads | Number of SELECT statements |
ResponseTime | ResponseTime | Tracks resource's response time. Metric measures how long it took to open an active connection to MySql database in milliseconds |
Size | DatabaseSize | Tracks database size in MBs |
Status | ResourceStatus | Tracks the overall readiness status of the monitored resource. Possible values are: Ready, Down, Stopped and Unknown |
TopQueries | DatabaseMySqlTopQueries | Tracks top 10 (by highest worker time) queries. Query text display is limited to 2000 characters |
WriteIOPS | AmazonCloudWatchMetric | Tracks Write IOPS of current database instance |
WritesCount | DatabaseMySqlWrites | Number of INSERT, UPDATE and DELETE statements |
Alert Name | Expression | Severity | Description |
---|---|---|---|
Database Approaching Max Size |
Size > 1900
|
Warning | Disabled by default. Fires an alert when the size of the database approaches maximum limit. Customize this alert with proper threshold according to specific database tier, before enabling it. More information on maximum service limits here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html#RDS_Limits.Limits |
Open Sessions Approaching Max Limit |
ConnectionsActive > 150
|
Warning | Disabled by default. Number of open connections (sesssions) is approaching maximum limit. Change the threshold in accordance to your database tier. More information here: https://sysadminxpert.com/rds-max-db-connection-limits-as-per-db-instance-type/ |
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 |
Slow Response |
ResponseTime > 15000
|
Warning | Raises an alert if establishing a connection to monitored resource takes over 15 seconds for sustained period of time |