What makes a CSO?
Choose Manage CSO from the drop-down. This opens up a form with the following details:
- 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.
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal