Run SQL scripts to fix SQL Server health check issues

Details when executing FixSQL script

Applies to

ApexSQL Manage

Summary

SQL Server instance health issues can be difficult to pinpoint and fix. The process can be long and tiresome, from analyzing the state of the SQL Server instance, summarizing the issues, and most importantly, to writing SQL scripts in order to resolve the issues.

This article describes the most important part, how to run the predefined FixSQL scripts and fix SQL Server health check issues in ApexSQL Manage.