DBA Cockpit for SAP Sybase ASE (New and Changed)

Historical Monitoring of Server Resources (New)

A new data collector ASE Resources and a new screen Performance  ASE Resources have been added. These enable historical monitoring of server resources as being reported through system procedure sp_monitorconfig.

Historical Monitoring of Disk, Network, and CTLIB Controller (New)

A new data collector I/O Controllers as well as a new screen Performance  I/O Controllers have been added. These enable historical monitoring of disk, network, and CTLIB controllers.

Dump History for Database Dumps (New)

SAP Sybase ASE collects a history of database and transaction log dumps. This dump history is available in screen Backup & Recovery  Database Dump History.

Customizable system and system landscape dashboards (New)

Dashboards are defined by a number of plug-ins, where each plug-in covers a certain aspect of the SAP Sybase ASE database monitoring in an overview-type manner. The following plug-ins are delivered:

• ABAP Dictionary Consistency

• Data Collection Framework

• Instance Overview

• Top Tables by Size

• Top Tables by Growth

• Top Tables by I/O

• Top Tables by Lock Contention

• Space Usage

• ASE Error Log

• Lock Manager

• Data Caches

• Device I/O

• Connections

• CPU Acitivity

• Disk I/O Activity

• Network I/O Acitivity

• Task Run Queues

• Replication

• ATM

Incremental Data Collection (Changed)

The semantics of incremental data collection have changed for data collector Tables. Space metrics of all tables are now collected only once a day, while performance metrics are collected for every execution. This allows more frequent scheduling of data collector Tables without harming system performance.

Discarding Cached Statements (New)

Screen Performance  SQL Statements  Statement Cache now allows you to drop a cached statement from the statement cache. Any related query plans are also discarded.

Detection of Missing or Incomplete Index Statistics (New)

A new screen Diagnostics  Table Statistics has been introduced. The new screen checks for missing or incomplete index statistics and provides an overview of "sticky" statistic settings.

Modification of ATM Configuration (Changed)

Modifications to the ATM configuration are now only permitted for the DBA Cockpit that owns the ATM configuration. The aim here is to prevent issues whenever two incompatible versions of the DBA Cockpit try to manage the same ATM configuration.

More Information

For more information about the DBA Cockpit and its functions, see Database Administration for SAP Sybase ASE on SAP Service Marketplace at http://service.sap.com/instguides  <Release>  Operations  Database-Specific Guides.