|
Bradmark’s Surveillance
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.
Out-of-the-box,
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.
In addition
to the Surveillance standard features set (listed
below), the following are specific features provided
for Sybase ASE:
| Key
Features/Benefits for Sybase ASE |
- Support for ASE 15.5
- Monitor SQL statements
and stored procedures on Sybase ASE:
- ASE Procedure Activity
Window
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
Statements Window
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
|
-
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
Back to
top
|
