System Performance Optimization: Tuning
Our consultants can perform work at your location or work remotely to analyze and tune your database system. PTC has the skills and tools to quickly determine the “root cause” of problems and improve the performance of the entire system environment. Our focus generally includes the entire architecture including the database, applications, servers, storage, and network infrastructure.
Our approach to the problem is scientific in nature. For example, a hypothesis is formulated and parameters (variables) are changed and measured to determine cause and affect relationships. Because there are many variables that impact system performance, tuning is really an iterative process. Therefore, most tuning engagements are 2-3 weeks in duration and some longer, depending on the size and complexity of the environment.
Every tuning engagement is different; however, below are some of the more common tasks performed during this type of engagement.
We\’ll monitor system performance and check for disk I/O rates and latencies, CPU, and memory usage. We\’ll attempt to identify and isolate specific performance issues and I/O bottlenecks. This includes an analysis of your entire system, including the network, server and storage systems.
System Performance Analysis.
We\’ll collect and analyze various performance counters and data over a period of time that best represents your business operations and application usage. This information provides us with solid understanding of how the application is used and a baseline for performance analysis and comparisons.
Database Server Analysis.
We\’ll analyze Oracle or SQL Server and operating system statistics to determine the overall health and usage of the system.
Stored Procedure and SQL Analysis.
We\’ll evaluate the system in terms of execution and try to determine if performance can be improved by either modifying SQL statements or execution plans.
We\’ll analyze the database schema in order to determine whether or not changes should be made. These changes may be immediate, such as a new index, or long term, such as partitioning or distributing the database.
Where appropriate, we\’ll recommend architectural changes, such as the use of a transaction monitor, cluster, or changes to LUN assignment, indexes or database layout.
Final Recommendations and Report.
Our final analysis will include an executive summary with recommendations and supporting details for improving your overall system design or configuration or defining and documenting a system configuration tailored to your specific application usage and growth requirements. System sizing is one area growing in popularity with many application providers and their customers.
“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”