Performance Tuning Methodology
A performance tuning methodology has many of the same characteristics as other engagement methodologies except that database performance tuning must be more flexible. When performing a system assessment, migration or implementation many of the tasks are similar and often repeatable. Although the analysis, hypothesis and implementation of performance tuning follow PTC’s methodology, the areas of focus will change based on initial analysis.
PTC’s performance tuning approach is top down in nature. During the first day of the engagement we will interact with your personnel, learn about your system, the application involved and your needs, as well as develop a high level analysis of the system’s performance and functionality. Upon initial investigation, we will then develop an approach to address our client’s issues and requirements. We take a holistic approach to performance analysis and tuning and therefore analyze the entire system and make suggestions to improve performance.
Areas of investigation typically include:
- Hardware architecture and configuration.
- Storage configuration and performance.
- Operating System configuration and performance.
- Database configuration and performance.
- Application performance (optional).
- Network and infrastructure analysis (optional).
We use this flexible approach because of the many potential areas to analyze and variables involved. Often we’ll not plan the entire engagement until we know which key areas to investigate. Most areas are usually analyzed, some more than others, depending on our findings. Below is a summary of PTC’s tuning methodology.
Performance Tuning Process: PTC’s tuning methodology is scientific and holistic in approach and often includes the entire system architecture (server, storage, operating system, database application, and network infrastructure). Therefore we’ve found a, tops down iterative approach to be most effective.
Top Down Iterative Process or “Step” Approach:
- Investigate issues and problems encountered
- Analyze system performance and functionality
- Provide initial hypothesis and recommend tuning approach
- Tune, test, validate results and if required, re-tune (“step” approach)
- Changes are categorized by risk
- Implement changes, one at a time
- Based on findings and results, make final recommendations
- Deliver final report and documentation
“Performance Tuning was able to quickly troubleshoot and resolve many technical issues that often eluded other consulting companies we’ve worked with. I was most impressed by their quick response in emergency situations. They’ ve been instrumental in the delivery of Oracle technologies such as Oracle RAC, Grid Control and Data Guard.”
“Performance Tuning was able to offer unique insights to database design and performance tuning optimization on a world class level. They did a superb job of load testing, which was cited by Microsoft (a team member) as, the best we’ve seen in three years and 50 customers to come through our SQL Server Performance Tuning Lab. This statement came from the SQL Server Product Group in Redmond – a tough crowd to please. In addition, they accelerated several products including our flagship Thomson ONE Analytics and were a key part of a project whose success has lead to case studies by Intel, Microsoft, and Unisys.”
“The Instructor was able to customize the course slightly to meet the needs and levels of experience in the class. It was great to get some real hands on to cement in what was reviewed and explained.”
“We recently had a problem with SQL Server performance after introducing virtualization and a SAN in our server environment. After working with two different consulting companies without success, we contacted Performance Tuning Corporation. PTC rapidly set up a remote engagement with us, and within one week was able to identify a problem with a virtual device driver. We are very satisfied with the work PFC performed, and feel it is some of the best consulting money that we have spent in several years.”
PTC has been phenomenal. It’s a scary time when your most critical data is being moved while users are in the system working. Especially on the heals of our previous vendor’s failed attempt. I can only describe it as a calming effect when true professionals are running the show.
“We are very pleased with the work that PTC performed. They were able to extract information from SQL Server and use that information to identify the exact causes of our performance bottlenecks. They provided us with information, tools, and instructions on how we can locate the cause of our performance problems. The final report contained good information and gives us a benchmark for doing future performance reviews.”
“This is a well balanced course (Optimizing Oracle RAC on Linux) covering all major topics from System Administration to Database Administration unlike most of the courses”