Analyzing long-term buffer pool performance

This function analyzes performance data from several bpd files according to your needs. The function is performed on the client, which means that the bpd files need to be downloaded before they can be used as input for the long-term analysis.

The client-based graphical user interface (GUI) provides the environment to select the bpd files to use, to specify the type of analysis to be performed, to specify counters and buffer pool objects of interest, and to view and save the result of an analysis.

Long-term analysis can mean anything, but ready-made results might not fit your needs and interests. The long-term analysis function of Buffer Pool Analyzer provides a flexible way of specifying your needs and provides instant results. The following procedure introduces the functionality and your interaction with this function:
  • You select the bpd files to be included in the analysis. Any number of bpd files existing on the client can be selected. You do not need to care from which subsystem they were created.
  • The long-term analysis function identifies the subsystems from which these bpd files were created. If multiple subsystems are involved, you need to choose one (which causes the function to ignore all bpd files from the other subsystems).
  • You select the type of analysis to be performed, which can be, for example, a weekly view by day, a daily view by hour, a view of a period of time, bar charts, or pie charts. Every type has its strengths and is instantly explained when you use this function.
  • You select the counters and buffer pool objects you are interested in and the relationships between them. Counters can be single counters, groups of counters, even ratios. Objects can be all objects, single objects, some or all in a buffer pool, a mixture from several pools, and more. You can also restrict the time frame to consider for the analysis. The long-term analysis function takes care that only those data from the bpd files is used for the analysis that matches your selections.
  • The long-term analysis function shows the result instantly in the main window. The result is kept on the client for future use and comparison with other results.

Analyzing long-term buffer pool performance describes how to use this function and also shows and explains several examples of the various analysis types.