Contents Index Use of work tables in query processing Obtaining database statistics from a client application

ASA SQL User's Guide
  Monitoring and Improving Performance

Monitoring database performance


Adaptive Server Anywhere provides a set of statistics you can use to monitor database performance. Accessible from Sybase Central, client applications can access the statistics as functions. In addition, the server makes these statistics available to the Windows  Performance Monitor.

This section describes how to access performance and related statistics from client applications, how to monitor database performance using Sybase Central, how to monitor database performance using the Windows Performance Monitor, and how to detect file, table, and index fragmentation.


Obtaining database statistics from a client application
Monitoring database statistics from Sybase Central
Monitoring database statistics from Windows Performance Monitor

Contents Index Use of work tables in query processing Obtaining database statistics from a client application