Surveillance IQ™ monitors, reports, and alerts for key performance and utilization metrics providing a turnkey monitoring solution for your Sybase IQ environment.
In addition to the Surveillance standard features set (listed below), the following are specific features provided for Sybase IQ:
Standard Features
- Monitor unlimited servers through its distributed agent architecture
- Real-time, proactive monitoring, event-driven alerting and task dispatching
- "Flashback" to the recent past and diagnose data to determine the root cause of an outage.
- Allow DBAs to share information between the various agents, minimizing data retrieval and overhead while maximizing efficiency on complex networks.
- Customizable client user interface that increases a DBA's effectiveness to view only the information they need to see.
- Easy integration of Surveillance alerts with existing network console systems, such as Tivoli or OpenView.
- Easy integration of existing SQL scripts into Surveillance, through the user-defined collection (UDC) capability.
- Produce high quality reports from the Surveillance Centralized Repository Database, and generate numerous pre-defined reports for each monitored platform.
Specific Features/Benefits for Sybase IQ
- Monitoring of Sybase IQ 15.3 is supported, with logical clusters, shared temporary stores, and PlexQ, or Distributed Query Processing (DQP)
- The Recently Executed Statements Window mines IQ SQL Log information on IQ 15
- Surveillance IQ provides real-time statistics on memory allocation, buffer and storage utilization, and disk and network I/O
- Ensure that your entire IQ Multiplex environment is healthy and available
- Monitor the key metric of Other Versions due to connections or Multiplex query servers
- Find recently-executed SQL for the database or specific connections
- Connections are shown with their resource utilization, detailed drilldowns to transactions, SQL, and lock information
- Monitor all open transactions and their resources
- Analyze space usage by external files such as the Catalog Store, Catalog Log, IQ Message File
- Alert on parameters that would take an IQ database offline or negatively affect its performance
- Report on table and column usage, index advice
