Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 485 / 536

465
C H A P T E R 1 3
Monitoring and Tuning
Performance
About this chapter This chapter describes tools you use to monitor Adaptive Server IQ
performance. Use these tools to determine whether your system is making
optimal use of available resources. To understand how Adaptive Server IQ
uses memory, process threads, and disk, and to learn about options you can
set to control resource use, see Chapter 12, “Managing System
Resources” See also the sections on performance implications and tuning
in other chapters of this guide for more tuning hints.
Viewing the Adaptive Server IQ environment
The first step in tuning Adaptive Server IQ performance is to look at your
environment. You have various options:
• Use system monitoring tools (each system and site has different tools
in place).
• Use one of the stored procedures that displays information about
Adaptive Server IQ. See the next section for more information.
• Determine appropriateness of index types. See Chapter 4, “Adaptive
Server IQ Indexes” for more information about choosing index types.
• For on-screen information, look at your insert and delete notification
messages. “Interpreting notification messages” gives more
information about these messages.
• Look at the IQ message file, called dbname.iqmsg by default.
Getting information using stored procedures
Adaptive Server IQ offers several stored procedures that display
information about your database: