This paper covers the tools and various methods available for tuning poorly executing MySQL SQL code. MySQL has a well deserved reputation as a light-weight and efficient database server capable of meeting the requirements of even the most demanding high volume web applications. Nevertheless, as the part of your application that does virtually all the disk IO, it's going to be the source of a significant proportion of your application response time. Therefore, if you want your application to meet its full performance potential, you should not shirk on tuning the MySQL SQL code. 
 
Written by Guy Harrison
PDF Document - 507kb

This white paper gives an overview of the core memory structures within DB2 LUW and how they can cause performance degradation. It then discusses how the new autonomic facilities can help minimize the effort required to monitor and maintain a DB2 instance for optimal performance.
 
Written by Jim Wankowski
PDF Document - 625kb 

Battling performance problems and tuning DB2 subsystems, databases, and applications is a constant chore for DB2 professionals. But performance tuning tasks can be simplified with the right knowledge, preparation, and tools. This white paper discusses how to prepare for some of the most common performance issues you will face as you manage DB2 applications; and how to ensure that you have useful, modern tools to guide your tuning efforts.

Written by Craig Mullins
PDF Document (278 kb)

One of the most critical performance aspects of an application is the actual SQL statement that either the application or the end-users execute to retrieve the data from DB2. Roughly 75 percent of all application performance problems result in poor performing SQL. T

he difficulty is that there are many semantically equivalent ways to write any given query, but to achieve optimum performance there are only a few. SQL is complex and requires endless hours to write and tune for performance. This whitepaper discusses the `Top 10` rules of thumb for ensuring your SQL is running at its best.

Written by Sheryl Larsen.  
PDF Document (669kb)

Data Sharing in DB2 provides the user with scalability and flexibility when it comes to increasing DB2 productivity and throughput. Using multiple subsystems as if it were a single system to manage the workload at hand, leads to improved response times and a happier user community. To many, this can sound like the pinnacle of DB2 scalability and processing power. However, as with everything else in the universe, there is a trade off. The trade off here is, unfortunately, in the form of increased complexity in managing performance. Knowing “what to look for,” or even just knowing “where to start,” can give a DB2 DBA an advantage in solving this complex performance puzzle.
 
For the purposes of this discussion we will focus primarily on the Coupling Facility (CF) and the DB2 related objects found there, namely Group Buffer Pools and Global Locks. Since the CF is the “glue” that holds the data sharing group together, we felt this would be the perfect place to lay the groundwork for tuning this environment.
 
Written by Scott Olsen.  PDF Document (513kb)

This whitepaper by Jim Wankowski discusses how to identify and resolve the most common areas of performance bottlenecks in DB2 running on Linux, Unix, Windows and z/OS. It compares/contrasts memory architecture, physical design, maintenance, and SQL tuning techniques for applications running in z/OS vs. Linux, Unix, or Windows. These topics are based on DB2 for z/OS V8 and DB2 for Linux/Unix/Windows (LUW) V9.1.

According to Quest expert Bert Scalzo, many problems associated with benchmarking can simply be solved through education. In this white paper, he addresses the ten most common fallacies about database benchmarking.  After reading it, you will have a better understanding of the steps you can take - and what you should avoid - to ensure your benchmarking efforts are successful.

The attached Word document describes how to define a custom session filter to find a specific SQL statement among many sessions currently running.   Thanks to Larry Bob at Boeing for this submission!

Are you curious about the new Oracle 11g SQL Replay facility?  SQL Replay allows the replay of a SQL workload and generation of a delta report to show which statements' performance have improved or regressed. 
 
Quest expert, Mike Ault, put SQL Replay through its paces.  Read about his tests and conclusions.

60kb PDF document.

This technical brief guides you through an overview of ' Database Development Best Practices for Oracle methodology. You'll learn the steps it takes to implement best practices within your organization. It delves into both the single user methodology and the project-wide methodology.