Using our tools and knowledge, we will provide a full SQL health check of your server farms by providing the following reports:
Routine Health Report
Shows the health of the SQL Server at a high level. Looks at best practices and compares them to the current state of the database.
SQL Server Detail Report
Documents key settings of the SQL server, including cluster information, DB recovery model, location of critical files, I/O, physical memory, wait types, logins and more.
Database Detail Report
Deeper dive into each individual database in the SQL server, including properties, missing indices, fragmentation levels and other stats.
Maintenance Plan Report
A very telling report that reveals which defined maintenance plans have been run, the last run times and results. The report includes the sub-steps taken in the plans
SQL Server Agent Jobs Report
This report includes a comprehensive list of all SQL Server agent jobs and their schedules. The Job History highlights which jobs were not successful, and why they are producing errors
