A Perspective on Database Performance Tuning

By Julian Stuhler – on Database Journal.com

Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer or systems administrator.

Last month, I covered IBM DB2 10 for z/OS: Justifying the Upgrade , and spoke briefly about the performance enhancements in that release that can help in justifying the upgrade to hard-nosed business execs looking for real return on investment for infrastructure projects.

In this article, I want to take a more general look at database performance tuning, and the reasons why it remains one of the most important topics for any DBA, developer or systems administrator. I’ll also cover some golden rules for performance tuning, which tend to apply regardless of the specific platform or application you’re responsible for.

Click here to read the full article.

For more information visit our database tuning web page.