Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and improving database performance » Improving database performance


Monitoring database performance

SQL Anywhere provides a set of statistics you can use to monitor database performance. There are three ways to access these statistics:

These methods are useful for monitoring in real time. However, you can also capture statistics as part of diagnostic tracing and save them for analysis at a later time. For more information about diagnostic tracing, see Advanced application profiling using diagnostic tracing.

For a complete listing of the SQL Anywhere statistics available for monitoring, see Performance Monitor statistics.

For more information about monitoring your database, see Monitoring your database.

Monitoring statistics using SQL functions
Monitoring statistics using Sybase Central Performance Monitor
Monitor statistics using Windows Performance Monitor