When tuning a database for better performance, one area to examine is the proximity of the database to the application. Can the database be located on the same server as the application? Will a database server located far away from the application server cause performance degradation? To answer these questions, a series of measurements were conducted to determine performance impact based on the distance between the application and database servers. This paper discusses the results of our tests.

IBM Redbooks | Local vs Remote Database Access: A Performance Test