User Login Bradmark Offices Bradmark Homepage Bradmark Homepage
About Bradmark Bradmark Product Solutions Professional Services/Training 24/7 Technical Support
Bradmark Authorized Partners
Bradmark Products
Oracle Solutions
Sybase Solutions
DB2 UDB Solutions
MS SQL Server Solutions

For all sales inquiries or additional product information, contact your regional Bradmark sales representative. 

24 Hours-a-day,
7 Days-a-week

(Printable PDF; 128K)

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

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


Back to top