SQL Anywhere provides a set of statistics you can use to monitor database performance. There are three ways to access these statistics:
SQL functions These functions allow your application to access SQL Anywhere database statistics directly. See Monitoring statistics using SQL functions.
Sybase Central Performance Monitor This graphical tool queries the database and graphs only those statistics you have configured the Performance Monitor to graph. See Monitoring statistics using Sybase Central Performance Monitor.
Windows Performance Monitor This is a monitoring tool provided by your Windows operating system. See Monitor statistics using Windows Performance Monitor.
Performance Statistics utility (dbstats) This utility provides monitoring of database server, database, and connection statistics for database servers running on Unix. See Performance Statistics utility (dbstats) (Unix).
SQL Anywhere Console utility (dbconsole) The utility provides administration and monitoring facilities for database server connections. See SQL Anywhere Console utility (dbconsole).
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
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |