(Printable PDF; 128K)
DB™ provides real-time diagnostics,
unattended event management, and historical analysis of the performance
and utilization of your Sybase ASE environment. Capture high-level comprehensive
views of the overall health of your ASE server, and drill-down
to the root cause of performance bottlenecks.
Surveillance’s unattended event management allows you to
get immediate feedback of performance issues on your ASE servers
throughout your enterprise. Highly customizable rule sets and
event handlers can then be tailored to your specific requirements
including taking remedial action. For after-the-fact problem
diagnostics, capacity planning, and service-level monitoring,
Surveillance’s Central Repository can store historical
performance and utilization information from the entire enterprise.
to the Surveillance standard features set (listed
below), the following are specific features provided
for Sybase ASE:
Features/Benefits for Sybase ASE
- Support for ASE 15.5
- Monitor SQL statements
and stored procedures on Sybase ASE:
- ASE Procedure Activity
For Sybase ASE 15.0.3 and later, the new Procedure
Activity Window provides performance statistics for stored procedures, such as
average and maximum elapsed times, CPU usage, and wait times.Support
for ASE Statement Cache
- Cached Statements
Window displays SQL and their statistics from the
ASE Statement Cache. A pane in the Cache Activity
Window provides overall statistics for the Statement
Cache.ASE Current Executing Statements Window
The Current Executing Statements Window has been redesigned to
include much more information for each SQL
statement that is currently running inside the database.
- ASE Recently Executed
For Sybase ASE 15.0.3 and later, the Recently Executed Statements
Window provides SQL monitoring statistics summarized by batch.
The collections provide better performance.
- Full SQL Text and
reduced SQL storage for ASE
Several windows, such as the Current Executing Statements Window,
have been enhanced to show a preview portion of SQL in each row,
and then the full SQL text in a lower window when single-clicking
on the row. The
amount of storage for SQL in local repository stores has been reduced
by up to 90% for some collections.
- SQL Text for ASE
in flashback mode
Several windows can now show full SQL text in flashback mode
- Various collections now
support ASE In-memory Database (IMDB)
- Utilize real-time statistics
available from Monitor Server, DBCC or MDA monitor views
- Improve performance using
ASE timed event profiles, process-level statistics, and
runtime query plans
- Monitor TempDB and transaction
log usage to prevent failures
- Get alerts on out-of-space
conditions in databases and segments
- Report on storage trends
and many other aspects of ASE
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