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.

PTC Update

  • Tune GoldenGate by capturing the before images from the Exception Table https://t.co/I2LDle66Lo https://t.co/f7wFIgxtxB 2 months ago
  • Do you have Exadata Excellence? We are hiring! Join a fast growing dynamic team. https://t.co/FUd1LlmBLn https://t.co/yMzQogmSf1 2 months ago
  • Are you a GoldenGate Guru? We are hiring! Join a fast growing dynamic team. https://t.co/eJf1VFxJx1 https://t.co/YO1ctI9cCL 2 months ago
  • We’re looking for Oracle DBA Consultants looking for rewarding careers. https://t.co/dSpWqkQO77 https://t.co/ivCEYnXhgb 3 months ago
  • Data Center Migration and Application Development Architect https://t.co/mCUt4qUf4Q https://t.co/jG262puAA1 4 months ago