Database Performance Assessment2017-10-21T04:37:30+00:00

Database Performance Health Check – Quickly and Easily Identify Database Performance Issues.

Database Performance Issues Solved in 3 days

Database Performance health Checks from Performance Tuning Corporation provide a quick, easy, and targeted service focused on arming you with clear evidence about the status of your database system performance and maintenance strategy. Whether you are experiencing problems now or want to know how you can improve your current database performance or maintenance plans, this Service will get you answers…and fast. We identify specific areas of poor performance and system bottlenecks, and review database maintenance plans for your Oracle or SQL Server database system, and provide recommended action.

A Database Performance Health Check consists of three steps:

  • Discovery and Data Collection
  • Data Analysis
  • Report Recommended Action

DAY 1: Discovery and Data Collection

  • First, we will set up a one-hour kickoff meeting with appropriate your team and PTC’s team of experts to:
    • understand the database system, applications, storage environment, and current maintenance strategy
    • determine the best method to collect data
    • determine best time(s) of the day to capture peak workloads
    • understand any known issues or existing symptoms, such as application timeouts, long running processes, deadlocks
  • Collect data with minimal effort by the client

DAY 2: Data Analysis

  • Perform data analysis and correlate data from multiple areas to understand relationship within the system
  • Review maintenance strategy and compare to PTC’s proven best practices
  • Note areas of interest and issues

DAY 3: Report Recommendations

  • Develop a summary report of findings and recommendations
  • Deliver report and discuss via WebEx conference with Client

The following are the general areas that will be reviewed and analyzed. These may be customized depending on client feedback and need.

Detailed Activities: SQL Server Health Check

  • Analyze system and storage configuration, resource utilization and performance including memory, CPU, disk I/O
  • Analyze SQL Server configuration, resource utilization, and performance. Data will be collected and reviewed in the following areas as appropriate:
    • Database configuration and parameter settings
    • SQL Server memory usage
    • Per database and per object memory usage
    • Database wait statistics
    • Database file layout on disk
    • Database file I/O statistics
    • SQL statements/stored procedures – identify top worst performing queries
    • Process blocking
    • Identify missing indexes
    • identify fragmented indexes
    • Database maintenance plans/jobs and schedule
    • Backup/Recovery procedures/schedule

Detailed Activities: ORACLE Health Check

  • Analyze system and storage configuration, resource utilization and performance including memory, CPU, disk I/O usage (may require installation of performance monitoring tool for Linux/UNIX systems)
  • Review Operating System configuration
  • Analyze Oracle configuration, resource utilization, and performance. Data will be collected and reviewed in the following areas as appropriate:
    • Database configuration and parameter settings
    • Oracle memory usage
    • Database wait statistics
    • Database file layout on disk
    • SQL statements/stored procedures – identify top worst performing queries
    • Process blocking
    • Identify fragmented objects
    • Database maintenance plans/jobs and schedule
    • Backup/Recovery procedures/schedule

Database Performance Health Check Deliverable:

DB Health Check Report: The final report will provide findings and recommendations with best practice information based on the above analysis. This will be reviewed and discussed on a call with client.

Latest From the Blog

Tuning Oracle Veridata

Edward Whalen 03/21/2019 Oracle GoldenGate Veridata - Tuning Oracle Veridata Oracle GoldenGate Veridata is the most effective tool for comparing, validating and repairing data between homogeneous and heterogeneous databases.  As powerful as it is, [...]

Setting up GoldenGate Replication with DIPC

Edward Whalen 03/07/2019 Setting up GoldenGate replication with DIPC is done from both the cloud console and from the GoldenGate home.  In this example I will be using an Oracle database source and an [...]

DDL Replication in GoldenGate

Edward Whalen 01/03/2019 DDL replication in GoldenGate is much easier in Oracle database version 12 and GoldenGate version 12.3 because of the native support for it.  In the past we used to have to [...]

What Our Clients Say

“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.”

James Jech, Dell

“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.”

Jeremy Lehman, Thomson

“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.”

Chad Aberle, Microsoft

“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.”

Howard Brill, PHD, Monroe Plan

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.

IT Healthcare Manager, Opelousas General Health System

“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.”

Jon Robertson, MedEvolve

“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”

Manish Bijlani, RealtyData Corp.

Our Clients

Over 1000 clients from all industries have benefitted from our database services