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. | ||||||||||||||||||||||
DatabaseSize |
Double
|
Tracks the size of the database in megabytes. | ||||||||||||||||||||||
DatabaseSqlBlockingQueries |
|
Tracks queries that are currently blocking each other, with specific SQL and session IDs. | ||||||||||||||||||||||
DatabaseSqlBlockingQueryCount |
Int32
|
Tracks the number of deadlocking queries. | ||||||||||||||||||||||
DatabaseSqlConnections |
|
Tracks currently open connections and their associated information (host, username, etc) to the monitored database. | ||||||||||||||||||||||
DatabaseSqlCurrentQueries |
|
Tracks currently executing queries and their associated information (host, username, SQL, etc.) | ||||||||||||||||||||||
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. | ||||||||||||||||||||||
DatabaseSqlTopQueries |
|
Tracks top 10 (by combined utilization) queries and their associated information (SQL, utilization, etc). This metric can help DBAs optimize ineffective queries. | ||||||||||||||||||||||
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 | ||||||||||||||||||||||
WindowsPerformanceCounter |
Double
|
Tracks performance counters defined as individual metrics. Any performance counter might be tracked. | ||||||||||||||||||||||
WindowsPerformanceCounterMultiInstance |
|
Tracks multi-instance performance counters. It returns an array of PerformanceCounterInstance objects for each counter instance. |
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 |
---|---|---|
BlockingQueries | DatabaseSqlBlockingQueries | Disabled by default. Tracks queries that are blocking each other (metric disabled by default because it can add load to the database) |
BlockingQueryCount | DatabaseSqlBlockingQueryCount | Tracks blocking (possibly dead-locking) queries |
ConnectionList | DatabaseSqlConnections | Tracks the list of open connections against the database. This metric is a multi-dimensional array |
ConnectionsActive | DatabaseActiveSessionCount | |
QueriesInProgress | DatabaseSqlCurrentQueries | Tracks currently executing queries |
ResponseTime | ResponseTime | Tracks resource's response time. Metric measures how long it took to open an active connection to SQL 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 | DatabaseSqlTopQueries | Tracks top 10 (by highest worker time) queries. Query text display is limited to 100 characters |
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 > 275
|
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 |