Bufferpool Monitoring

Surveillance of SQL Quality & DSCA
You definitely can monitor and tune the pools independently from application/SQL tuning, and you will achieve immediate success from this. However, it indeed makes sense to pursue an integrated approach. A capable bufferpool analysis tool indicates not only suboptimal bufferpool behavior, it also should identify objects that are frequently accessed by inefficient SQL statements. Today, dynamic SQL makes more and more trouble. To deliver the proper analysis, it should link bufferpool analysis with the analysis of the dynamic statement cache.