SQL Server Health & Configuration Check
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
- 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.