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.

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

5. Double-click on "Full Compares/sec."
6. 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.
7. Start ISQL.
8. Connect to the same database as SQL Central.
9. 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]