Reducing hardware costs using Buffer Pools and Index Tuning

Date: 
Wednesday, 9 lipanj, 2004 - 10:00 - 11:00
Speaker: 
Tapio Lahdenmaki

In many companies DB2 tuning is now more about reducing costs than about improving response times. Wise trade-offs require up-to-date knowledge of hardware prices on a common scale (CPU second, 1 GB of central storage per month, 1 GB of read cache per month, 1 GB of disk space per month).
The presentation suggests a cost model, which can be tailored to your environment. It also discusses the tuning areas that have the highest potential for cost reduction. Index improvement is covered in detail with numerous examples.

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023