Sql Server Health Checks

SQL Server Health Check is a comprehensive assessment that is designed to validate the architecture, database design and code review for our clients’ database management systems. It provides:

• •   An accurate overview of their current database management system              environment – Strengths, Vulnerabilities, Opportunities and Roadblocks;

• •   Prepare for enterprise level migrations, upgrades or configuration of SQL      Server, Windows OS, and Storage;

• •   Assist them in identifying obstacles to Manageability, Availability                     Reliability, and Scalability (M.A.R.S), and;

• •   Address any caveats pertaining to security, database integrity checks, and      access management.

DMI SQL Server Health Check assessment report provides

• •   Comprehensive list of current performance issues focusing on CPU,                Memory, Storage/SAN etc;

• •   Detailed review of current maintenance strategies

• •   Review of schema layout, review indexing strategies focusing on                     duplicate indexes, missing indexes and unused indexes