SQL Server Health Check: 3-Day Assessment

Denny Cherry & Associates Consulting

Over 3 days Denny Cherry & Associates Consulting will review your existing SQL Server environment and provide a list of changes, which if made will improve the performance of your SQL Server.

If you’re experiencing significant performance problems, or are having a lack of resources to contend with consider a more in-depth analysis is the next step to take.

This three-day evaluation focuses on your Azure SQL Server instance and includes:

  • Comprehensive script to verify settings/configuration meet best practices
  • Deep review of the instance: database sizes, schema problems, missing, duplicate & unused indexes
  • Reviewing wait stats & queries captured on the Azure SQL Server Virtual Machine looking for problems
  • Documented report along that includes a checklist of steps to resolve issues found

The health check process is designed to be run against existing Azure SQL Server Virtual Machine.

https://store-images.s-microsoft.com/image/apps.26983.994d4817-c2fd-4e04-8a6b-af23b0f0aca3.bb856ee2-05cf-4150-b2e9-51c2d91f7d3d.d6262400-6d51-43e5-a7e3-d6c8af7d9ddb
https://store-images.s-microsoft.com/image/apps.26983.994d4817-c2fd-4e04-8a6b-af23b0f0aca3.bb856ee2-05cf-4150-b2e9-51c2d91f7d3d.d6262400-6d51-43e5-a7e3-d6c8af7d9ddb