SQL Server Health & Configuration Check

A Health Check for SQL Server is a documentation of the actual state of a system. Also included are a couple of performance indicators that may serve as a small baseline.

A Health Check ensures that the SQL Server instances meet a minimum configuration standard and that no basic erroneous settings or suboptimal default settings are present.

By contrast, the large-scale Health Check takes it a step further in that it adjusts the results as much as possible to your specific environment, with your participation (i.e. by completing a questionnaire), whereas the “small-scale Health Check” takes general standards as the basis.

The result, in the form of a documentation, can also be used as a baseline for

  • IT audits
  • performance analysis measures that may orientate themselves along this baseline
  • troubleshooting
  • a new setup and disaster recovery.

As a form of IT auditing, it helps

  • anticipate potential problems
  • implement best practices and iteratively develop one’s own, which in turn may result in improved availability and performance
  • standardize SQL Server configuration across all levels of the institution.

More than 15 years of experience with SQL Server systems have produced a Health Check that comprises up to over 60 points in the following areas:

  • Hardware configuration
  • Operation system setting
  • Windows Failover Clustering (when in use)
  • SQL Server setting
  • SQL Server security (high level)
  • Database settings
  • Database maintenance
  • SQL Server Agent jobs
  • configuration & evaluation error logs
  • Performance baseline (small-scale format)
    • Before/after comparison if a Health-Check of the last 6 months is available
  • Status check High Availability and DR
  • General recommendations according to Sarpedon Quality Lab® standards

Learn more about the benefits and ask for your individual offer. Contact me here.