(Printable PDF; 164K)
SurveillanceIQ™ monitors, reports, and
alerts for key performance and utilization metrics providing
a turnkey monitoring solution
for your Sybase IQ environment.
In a Sybase IQ multiplex environment, “other versions” resolution
is a time-consuming, manual process requiring a DBA to collect
information from every server. The new multiplex alerts and comprehensive
dashboard provide proactive monitoring and quick problem diagnosis
availability and reduce the time spent by DBA staff solving
issues. DBAs can also analyze external files such as the
Catalog Store, Catalog Log, IQ Message File, and the server
for size and available space, and the configuration view
shows the IQ configuration settings.
to the Surveillance standard features set (listed
below), the following are specific features provided
for Sybase IQ:
Features/Benefits for Sybase IQ
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
Monitor the key
metric of Other Versions due to connections or
SQL for the database or specific connections
shown with their resource utilization, detailed
to transactions, SQL, and lock information
Monitor all open transactions
and their resources
Analyze space usage
by external files such as the Catalog Store,
IQ Message File
Alert on parameters
that would take an IQ database offline or negatively
Report on table and column
usage, index advice
servers through its distributed agent architecture
proactive monitoring, event-driven alerting and task dispatching
the recent past and diagnose data to determine the root
cause of an outage.
to share information between the various agents, minimizing
data retrieval and overhead while maximizing efficiency
on complex networks.
client user interface that increases a DBA’s effectiveness
to view only the information they need to see.
of Surveillance alerts with existing network console systems,
such as Tivoli or OpenView.
of existing SQL scripts into Surveillance, through the
user-defined collection (UDC) capability.
quality reports from the Surveillance Centralized Repository
Database, and generate numerous pre-defined reports for
each monitored platform
Back to top