Performance problems are caused by many issues, ranging from poor application design or poor database design, to misconfigured database software or operating system, network, or storage configuration. By following an established process to isolate bottlenecks, we can quickly identify and solve your performance issues.
Our Oracle Performance Tuning, SQL Server Performance Tuning, and MySQL Performance Tuning service will find and fix these performance problems.
The Buda Consulting Performance Tuning System identifies high impact, fast resolution issues first, and then drills deeper to resolve more difficult problems that take more time and analysis to resolve.
Typically, the greatest benefit will come from application and index tuning, but that takes the longest amount of time to analyze and tune, so we start by looking at the issues that can be detected and corrected easily. These can sometimes make a substantial difference. We follow this systematic process to identify performance bottlenecks quickly:
- Examine the resource usage at the operating system level. We look for memory contention, processor contention, or disk contention. This informs the remainder of the process.
- Analyze and make recommendations to optimize your Database Software Configuration parameters and operating system configuration to ensure that you are properly utilizing available system resources.
- Evaluate the size, distribution, and switch frequency (for Oracle) of your transaction or redo logs to look for log contention.
- Ensure that database optimizer statistics are current.
- Evaluate I/O distribution and make recommendations to optimize the location of your data to ensure that you will not have IO bottlenecks.
- Examine the database design with respect to the nature of the applications. Ensure that the design accommodates the characteristics of the application such as OLTP vs OLAP. Look for presence of indexes and proper normalization.
- Analyze and make recommendations for optimizing your applications to ensure that they are designed efficiently and that you are properly using available indexes. Look for opportunities to minimize cursor usage and maximize the use of set operators.
Using this system, we have brought significant gains in performance to client’s systems. Please visit our case studies page for more information.
Our whitepaper on Oracle Database Performance describes some of the frequent problems that we have seen at client sites and how we resolved them.
Our Oracle Tuning, MySQL Tuning, and SQL Server Tuning services improve your response time and get you back to work!
