A 360 degree health check to identify and alleviate database bottlenecks

  • A Database Health Check is a short consulting engagement ( 2 to 4 weeks ) that analyzes current database performance and identifies specific steps to improve database related issues and risks.
  • The Database Health Check offering applies proven processes and expertise to sharpen database performance, reliability, and recovery.
  • The database environment health check looks at the risks and competencies in elements surrounding the database including security, infrastructure, and work management processes
  • The health check also can provide insight into other IT areas where the Client could use additional Mphasis services.
  • Following are the three main areas covered in Database Health Check, depending upon the requirement:

    Performance Health Check

    The Database Performance Health Check focuses solely on the technical efficiency aspects of one or more databases such as:

    ο
    Database Configuration
    ο
    Database Statistics
    ο
    Object Configuration
    ο
    Database Feature Usage
    ο
    Capacity Management
    ο
    Workload Management

    Environment Health Check

    The database Environment Health Check looks at the risks and competencies in elements surrounding the database including security, infrastructure, and work management processes

    ο
    Business Continuity
    ο
    Data Security and Audit
    ο
    Database Design
    ο
    Backup and Recovery
    ο
    Scalability
    ο
    Work Management Processes
    ο
    Storage Management

    Application Health Check

    The Application Health Check deals with the data, connectivity and other DB related areas from application perspective as given below:

    ο
    Data Architecture
    ο
    Data Quality
    ο
    Data Life Cycle
    ο
    DB Connection Design

Case Studies

A leading Telecom Company, the MF DBA team did a major Health Check and provided recommendations. Mphasis also implemented the recommendations resulting in significant reduction of MIPS

The Mphasis Advantage

  • Health check reviews covers overall database and environment and its impact on business
  • 360 degree Health check - covers performance, infrastructure, work management and security
  • Report Business issues, risks and opportunities
  • Proposed scope , roadmap and project plan for recommended next steps

Midrange

  • Oracle
  • Oracle ERP
  • Sybase
  • MS SQL Server

Mainframe

  • DB2