Bmc Software, Inc.

Donnell W Roach

A main memory of at least one computing device may be monitored to determine available main memory for a fixed buffer pool storing a first set of data objects accessible by an application. A virtual buffer pool stored in a secondary memory of the at least one computing device and storing a second set of data objects accessible by the application may be monitored. Object performance profiles that include an object performance profile for each data object of the second set of data objects may be generated. A transfer trigger for selecting a candidate transfer object from the second set of data objects for transfer to the main memory may be determined, based on the object performance profiles. The candidate transfer object may be transferred from the secondary memory to the fixed buffer pool to be included in the first set of data objects, in response to the transfer trigger.

Dynamic page fix optimization for database objects

For each database subsystem in a plurality of database subsystems running in a logical partition (LPAR), the systems and techniques include collecting data from buffer pools on a periodic interval, monitoring real storage availability on the LPAR, calculating an input/output (I/O) intensity score for each buffer pool for the periodic interval, ranking the buffer pools based on the I/O intensity score, calculating a cumulative I/O intensity score for each buffer pool across a cycle of multiple periodic intervals, ranking the buffer pools based on the cumulative I/O intensity score, and selecting a buffer pool candidate for page fixing. The buffer pool candidate for page fixing is a highest-ranked buffer pool from the plurality of buffer pools during the cycle based on the cumulative I/O intensity score that satisfies the real storage availability on the LPAR.

Growing community of inventors

Houston, TX, United States of America

Donnell W Roach