Foxhound is the better* Database Monitor for SQL Anywhere.
*better: More thorough, more relevant, more effective.
...more Alerts, more All Clears, more details, more control in your hands.

[Home] [Table of Contents] [Previous Section] [Next Section]

Breck Carter
Last modified: February 12, 1998
mail to:

Tip 77: Sybase SQL Anywhere
Performance Tips & Techniques

24 - Use The SQL Central Performance Monitor

The SQL Central Performance Monitor window can be used to watch for various performance problems while your database server is running. Here is a step-by-step demonstration of how to start SQL Central and watch the "Full Compares/sec." index lookup statistic:

  1. Start the database server.
  2. Start SQL Central: C:\sybtools\win32\scview.exe
  3. Connect SQL Central to the database.
  4. Open the Statistics display as shown in Figure 24A.

Figure 24A - SQL Central Statistics Window

  1. Double-click on "Full Compares/sec."
  2. Check "Graph statistic in the Performance Monitor" and click on OK. At this point a flat line (zero) graph of "Full Compares/sec." will appear in the Performance Monitor window.
  3. Start ISQL.
  4. Connect to the same database as SQL Central.
  5. Repeatedly do a wide entry index lookup as in Figure 24B. Now you should see a peak in the SQL Central Performance Monitor window as shown in Figure 24C.

Figure 24B - Force A Wide Index Lookup

SELECT * FROM indexed1

WHERE search1 = 'aaaaaaaaaa1001';

Figure 24C - Full Compares/sec. In The SQL Central Performance Monitor

[Home] [Table of Contents] [Previous Section] [Next Section]