The first step in tuning Sybase 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 the dynamic performance monitor in Sybase Central. See “Monitoring performance statistics”. For multiplex performance monitoring, see Using Sybase IQ Multiplex.
Use one of the stored procedures that displays information about Sybase IQ. See “Getting information using stored procedures”.
Use procedure profiling to track execution times for stored procedures, functions, and events. See “Profiling database procedures”.
Determine appropriateness of index types. See Chapter 6, “Using Sybase IQ Indexes” in System Administration Guide: Volume 1 for more information about choosing index types.
For on-screen information, look at your insert and delete notification messages. Chapter 7, “Moving Data In and Out of Databases” in System Administration Guide: Volume 1 gives more information about these messages.
Look at the Sybase IQ message file, called dbname.iqmsg by default.
