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. | ||||||||||||||||||||||||||
DatabaseOracleBlockingQueries |
|
Tracks queries that are currently blocking each other. | ||||||||||||||||||||||||||
DatabaseOracleCache |
|
Tracks information about library cache activity such as hit ratio, reloads, etc. | ||||||||||||||||||||||||||
DatabaseOracleCacheAdvice |
|
Tracks the predictive models for Oracle RAM areas. Each row contains the prediction of the number of physical reads for the cache size corresponding to each row. | ||||||||||||||||||||||||||
DatabaseOracleCacheMisses |
Double
|
Tracks the number of times the parsed representation did not exist in the cache. | ||||||||||||||||||||||||||
DatabaseOracleCacheMissRatio |
Double
|
Tracks the percent of times the parsed representation did not exist in the cache. Calculated as a ratio of cache misses to executions. | ||||||||||||||||||||||||||
DatabaseOracleExecutions |
Double
|
Tracks the number of times the parsed representation was requested. | ||||||||||||||||||||||||||
DatabaseOracleTopQueries |
|
Tracks top 10 longest running queries. The query text display is limited to 100 characters. | ||||||||||||||||||||||||||
DatabaseOracleUtilization |
Double
|
Tracks various database statistics such as cache hit rate, performance metrics, etc. | ||||||||||||||||||||||||||
DatabaseOracleUtilizationByClass |
|
Tracks various database statistics such as cache hit rate, performance metrics, etc.. | ||||||||||||||||||||||||||
DatabaseSize |
Double
|
Tracks the size of the database in megabytes. | ||||||||||||||||||||||||||
DatabaseSqlBlockingQueryCount |
Int32
|
Tracks the number of deadlocking queries. | ||||||||||||||||||||||||||
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 |
---|---|---|
BlockingQueryCount | DatabaseSqlBlockingQueryCount | Tracks blocking (possibly dead-locking) queries |
CacheAdvice | DatabaseOracleCacheAdvice | Tracks the predictive models for Oracle RAM areas |
CacheInformation | DatabaseOracleCache | Tracks information about library cache activity |
CacheMiss | DatabaseOracleCacheMisses | Tracks the number of times the parsed representation did not exist in the cache |
CacheMissRatio | DatabaseOracleCacheMissRatio | Tracks the percent of times the parsed representation did not exist in the cache |
ConnectionsActive | DatabaseActiveSessionCount | Tracks number of open connections to the database |
Cpu | AmazonCloudWatchMetric | Average value of CPU utilization for the monitored SQL Amazon database |
ReadIOPS | AmazonCloudWatchMetric | Tracks Read IOPS of current database instance |
ResponseTime | ResponseTime | Tracks resource's response time. Metric measures how long it took to open an active connection to Oracle 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 | DatabaseOracleTopQueries | Tracks top 10 (by highest worker time) queries. Query text display is limited to 100 characters |
WriteIOPS | AmazonCloudWatchMetric | Tracks Write IOPS of current database instance |
Alert Name | Expression | Severity | Description |
---|---|---|---|
Blocking Queries |
BlockingQueryCount > 0
|
Warning | Raises an alert when blocking queries are detected for 5 minutes sustained |
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 > 300
|
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 |