Articles & Content

Archives

Performance Tuning Shared Memory SQL related Caches (M04)

Topic: Informix

Subtopic: 2007



DATE: 2007-5-7 (04:20 PM - 05:20 PM)
SPEAKERS: Mark Jamison (IBM Information Management)

Performance is a key database requirement, and one of the primary places to improve performance is in monitoring and tuning the various SQL related caches that are available to tune in IDS 10.00. This presentation will discuss the 4 primary caches that can be tuned, best practices for tuning them and the best way to monitor them. Additional methods to monitor these caches in 10.50 will also be discussed.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

How to monitor the SQL related caches

How to set the SQL related caches

Best practices to tune the 4 SQL related caches

Changes in 10.50 that affect the SQL related caches

What minor Caches are affected by the primary 4 caches



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.