(Printable PDF; 164K)

Bradmark's Surveillance IQ provides a dashboard view of the health of the IQ environment. It is a comprehensive monitoring, alerting and historical reporting solution which is simple to install and administer, and integrates easily into existing monitoring frameworks. The use of Bradmark Surveillance IQ will help organizations maximize the availability and performance of their Sybase IQ investment.

High level Health View
The real-time diagnostics include a high level health view allows the administrator to get a quick snapshot of activity statistics, memory allocation and buffer utilization, storage utilization, disk IO and network IO.

Server Information
As a complement to the Sybase IQ metrics, the monitoring solution provides an overview of the key metrics of the server, including CPU utilization, Disk I/O, Memory Usage, Swap Usage and a count of the OS processes running.

Connection Detail
The Connection view provides a list of connections and their resource utilization to quickly identify intrusive connections. The administrator can quickly drill down into a detailed connection view, including detailed transaction, SQL and lock information that provide a comprehensive view of a connection and the resources it is using.

External Files Storage Analysis
By integrating server information, the External Files storage analysis is able to list not just the current size of key IQ files (Catalog Store, Catalog log, IQ Message File, and the server log directory), but also the space available for them to grow in their respective file systems.

Back to top

Alerting
Surveillance's powerful alerting technology lets an administrator know when a threshold (user-configurable) has been reached. Alerts include pop-up windows on administrator screens, emails, SNMP traps, HP OpenView events, Tivoli events, and even the possibility of automatically launching a fix-it script. The following pre-defined rules and alerts are standard, and it is very easy to copy and modify existing rules, or even generate new rules from scratch.

Key Rule Analysis and Alerting:

• Alerts the DBA when an IQ database becomes unavailable.

• Alerts the DBA when the temporary store is approaching 100%

• Alerts the DBA before database outages occur from insufficient free space in OS file systems for important IQ files such as the IQ Message Log.

• Alerts the DBA when there are excessive old versions utilizing a high percentage of storage capacity.

• Alerts the DBA when temporary buffer utilization is approaching 100%, a situation that causes the IQ system to run very slowly.

• Alerts the DBA when IQ memory allocated exceeds the physical memory of the system which can cause thrashing.

• Alerts the DBA when transactions have been opened for an excessive amount of time, which may be a cause of system resources not being released

Reporting
Surveillance IQ provides historical data collection and reporting, either on a server by server basis or in a centralized database. Examples of Reports:

• Resource usage reports for all IQ resource metrics that can be produced at a detail level for short periods of time, or a summary level by day or month for long term capacity planning.

• Consolidated view of errors across all IQ servers on the network to help the administrator analyse faults at a global level

• Historical view of configuration options over time to help the administrator perform impact analysis of changes.

Back to top