Articles & Content

Archives

Performance Tuning Shared Memory SQL related Caches (M04)

Topic: 2007 NA

Subtopic: Informix



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



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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