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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Performance improvements, diagnostics, and monitoring

SQL Anywhere Monitor, Cockpit, and Profiler comparison

The Cockpit shows you what your database server is doing, the Monitor shows which database servers are currently available, and the Profiler helps you investigate why your database is slow.

Cockpit

Use the Cockpit to quickly find out what is currently occurring in a database server and the databases on which it runs, and to receive email notifications when issues arise. In addition to highlighting database server issues, the Cockpit makes it easy to view information about your connected users, database, and database server properties, as well as database server messages.

Profiler

Use the Profiler to troubleshoot and fine tune your applications during development, as well as in production. The Profiler can log all SQL statements running in your database, including those from within stored procedures, triggers, and events. Use the stored SQL profiling feature to compare and benchmark the run times of these stored SQL objects against alternative implementations. Profiling all statements also provides detailed views of blocked and deadlocked connections.

Monitor

Use the SQL Anywhere Monitor to see the health and availability of all your servers in the enterprise, and receive notification emails when issues arise. The Monitor handles multiple databases, database servers, MobiLink servers, and server farms, as well as web servers, proxy servers, and host computers.