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 | ||||||||||||||||||
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 | |
---|---|---|
CustomSqlDatabaseScript | Runs custom SQL script on specified database | |
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 |
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 |
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 |
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. |
Open Sessions Approaching Max Limit |
ConnectionsActive > 150
|
Warning | Disabled by default. Number of open connections (sesssions) is approaching maximum limit. |
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 |