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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Performance monitoring and diagnostic tools


Monitor database performance

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

  • SQL functions   These functions allow your application to access SQL Anywhere database statistics directly.

  • Sybase Central Performance Monitor   This graphical tool queries the database and graphs only those statistics you have configured the Performance Monitor to graph.

  • Windows Performance Monitor   This is a monitoring tool provided by your Windows operating system.

  • Performance Statistics utility (dbstats)   This utility provides monitoring of database server, database, and connection statistics for database servers running on Unix.

  • SQL Anywhere Console utility (dbconsole)   The utility provides administration and monitoring facilities for database server connections.

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.

 See also

SQL functions used to monitor statistics
Sybase Central Performance Monitor features for monitoring statistics
Monitor statistics using Windows Performance Monitor