SQL Performance analysis and review of 1 instance of SQL Server, SQL Database or SQL Managed Instance
If you’re experiencing significant performance problems in your SQL Server instance or Azure SQL Database and need to investigate how you can improve the performance to meet the expectations, this 2 day assessment is for you. This 2 day assessment focuses on your SQL Server instance and includes:
Day 1: Review of configuration to verify settings/configuration meet best practices Review of the instance: database sizes, execution plans, schema problems, missing, duplicate & unused indexes Collection and analysis of wait stats & queries captured on the SQL Server looking for problems
Day 2: Documented report along that includes recommendations of steps to resolve issues found Online meeting with a presentation of the report
The assessment is designed to be run against an existing SQL Server instance on premise or in Azure, Azure managed instance or Azure SQL Database.