Azure SQL Database Tuning: 1 week implementation

Crayon Database Tuning and Optimization is an Azure database tuning and SQL Server optimization service designed for all organizations that want to improve the efficiency of the database environment.

Features:

• increasing the efficiency of the database environment
• increasing the stabilization of the database environment
• streamlining database administration by ensuring that administrators can focus on other work and ensuring the continuity of business services
• reducing the risk associated with the so-called "downtime", in other words reducing the risk of downtime caused by an inefficient environment
• potential savings related to investments in new IT infrastructure and the purchase of licenses
• tuning of database environments located in the on-premises environment, database environments located in the Microsoft Azure cloud – including those located in PaaS and IaaS services (Azure SQL Database, Azure SQL Managed Instance, Virtual Machines)

Project:

• workshop during which server and database parameters are collected
• setting the target parameters of database tuning (option)
• document after audit with recommendations for changes
• estimation of the costs of applying changes (option).
• implementation of changes (option)
• supervising the implementation of recommendations (option)
• conduct performance tests after changes (optional)
• verification of the introduced changes after a set time and presentation of the results (option)

Deliverables:

• workshop on environmental assessment
• scan a database instance
• document after audit with recommendations for changes