Light Weight Health Check
The Light Weight Health Check looks at Windows & SQL Server settings and configurations on the SQL Server Instance to ensure industry recommended practices are being utilized. Additionally, some performance metrics will be collected and analyzed to ensure the SQL Server is running optimally.
On completion of the Light Weight Health Check a detailed report outlining any potential configuration issues is provided and can be used internally or SQL Masters Consulting can implement the recommendations.
Deep Dive Health Check
The Deep Dive Health Check is a three day++ engagement utilising the Light Weight Health Check to gather the Windows & SQL Server settings and configurations on the SQL Server Instance.
The capture of performance counters is to provide a more in-depth review of the SQL Server Instance as well as Indexes, Database Integrity, Database Recovery Options, Database Security and identifying SQL queries showing performance problems.
On completion of the Deep Dive Health Check a detailed report outlining any potential configuration issues or performance bottlenecks is provided and can be used internally or SQL Masters Consulting can implement the recommendations.
++ – Subject to the size of the environment.
For more information on how SQL Masters Consulting can assist you with your SQL Server Health Check please peruse our SQL Server Health Check Brochure.