...
- SQL: Any user defined SQL which returns a result set.
- Key Columns: CSOs work with a result set which has unique rows. A combination of one or more columns of the result set can be made as a key column as long as long as this key column identifies a unique row in the result set.
- Server(s): Comma separated names of the servers for which this SQL needs to be queried every Collection Interval.
- Data Collection Interval: Interval in which this SQL is queried periodically. We recommend five minutes which also happens to be the default value.
- Purging Interval: The data retention time & we recommend seven days.
Image Added
Making its CSC
We create a CSC like any other monitor. Go to monitors page and select Add new monitor from the drop-down
- Enter the name of the counter being added.
- Type in the name of the group to which this counter is being added.
- Choose the type of counter as Custom SQL.
- Formula: A MySQL server parameter that is needed to compute the value of this counter.
- Value: This defines a function that computes the value. Below, you can find a template:
Code Block |
---|
|
function() {
var sqlObject = MONyog.UserObject('<Name of your Custom SQL Object>');
if (!sqlObject || !sqlObject.isEnabled() || !MONyog.MySQL.Custom.Available)
return '(n/a)';
/* You will have to call select here to fetch the resultset. */
var resultSet = sqlObject.select();
var results = ''; /* results holds the resultset in the form of array of row(s).*/
/*Get column(s) for each row from the result set */
for (i in resultSet) {
if (resultSet.length > 0)
results += '<br>';
results += resultSet[i].<Column name in resultset> +
'.' + resultSet[i].<Column name in resultset>;
}
if (results.length == 0)
results = 'None';
return results;
} |
- Description: Description of Monitor/Advisor.
- Advice Text: Advise text to the Monitor/Advisor being added.
Scroll pdf ignore |
---|
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legalalias | IDERA |
---|
url | http://www.idera.com |
---|
| | Newtabfooter |
---|
alias | Products |
---|
url | https://www.idera.com/productssolutions/sqlserver |
---|
| | Newtabfooter |
---|
alias | Purchase |
---|
url | https://www.idera.com/buynow/onlinestore |
---|
| | Newtabfooter |
---|
alias | Support |
---|
url | https://idera.secure.force.com/ |
---|
| | Newtabfooter |
---|
alias | Community |
---|
url | http://community.idera.com |
---|
| | Newtabfooter |
---|
alias | Resources |
---|
url | http://www.idera.com/resourcecentral |
---|
| | Newtabfooter |
---|
alias | About Us |
---|
url | http://www.idera.com/about/aboutus |
---|
| | Newtabfooter |
---|
alias | Legal |
---|
url | https://www.idera.com/legal/termsofuse |
---|
|
|