Tip 77: Sybase SQL Anywhere
Performance Tips & Techniques

25 - Use The NT Performance Monitor

The NT Performance Monitor is preferable to SQL Central because it offers more statistics and it is not intrusive (the results aren't skewed by running the monitor itself). Here is a step-by-step demonstration of how to start the Performance Monitor under NT4 and watch the "Full Compares/sec." index lookup statistic:

1. Start the database server.
2. Click on the NT4 desktop Start menu button.
3. Pick Programs - Administrative Tools - Performance Monitor.
4. Pick Edit - Add To Chart...
5. Highlight "SQL Anywhere" in the "Object:" drop-down list. If "SQL Anywhere" doesn't show up in the Object list then try installing SQL Anywhere again. It works OK when SQL Anywhere 5.5.01 Build 1333 is installed on Windows NT 4.0 Workstation.
6. Highlight "Full Compares/sec." in the "Counter:" drop-down list.
7. Highlight "1.0" in the "Scale:" drop-down list. At this point the Add to Chart window should look like Figure 25A.

Figure 25A - Configuring The NT Performance Monitor

8. Click on Add, then Done. At this point you should see a flat line (zero) graph of "Full Compares/sec." in the Performance Monitor window.
9. Start ISQL.
10. Connect to the same database as SQL Central.
11. Repeatedly do a wide entry index lookup as in Figure 25B. Now you should see a peak in the Performance Monitor window as shown in Figure 25C.

Figure 25B - Force A Wide Index Lookup

SELECT * FROM indexed1 WHERE search1 = 'aaaaaaaaaa1001';

Figure 25C - Full Compares/sec. In The NT Performance Monitor

---

[Home]

[Table of Contents]

[Previous Section]

[Next Section]