Sybase 12.4.2 manual Viewing the Adaptive Server IQ environment, 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:

465