High Available Architectures and Capacity Planning with WebSphere Remote Server V6

Chapter 11. Performance tuning of DB2 UDB Workgroup Server 355

The

Memory Visualizer is a part of the Health Center. With the Memory

Visualizer, you can monitor the memory usage such as sort heaps, buffer pools,

and caches. It displays the memory allocation for a particular instance and all of

its databases. Because many of the memory configuration parameters are

dynamic, you can change these parameters and monitor whether your change

has the expected result.

11.4.6 Design Advisor

Indexes play an important part in tuning the performance. An index is good when

retrieving data because data access is, in general, much faster through an index

than scanning an entire table to find matching rows. However, having indexes is

also an overhead. An inde ...