Database Training Days 201: Moving SQL Workload to the Cloud with MSSQLTips

Microsoft Azure SQL (DB and Managed Instance) are “fully managed” SQL Server database services. If you’re familiar with SQL Server, you'll find them easier to set up and use than traditional on-premises databases. Many DBA tasks, such as space allocation, backup, and recovery, are handled automatically by the platform. Plus, not having to worry about an operating system, hypervisor, and thread count further simplifies performance management. However, you can't afford to become complacent. The performance of any database as a service is directly tied to cost, and a poorly optimized workload can lead to the provisioning of extra resources. While it's great that Azure SQL can scale automatically to stay within SLAs, this can quickly increase costs if left unchecked. The performance challenge has evolved with the database as a service, but it hasn't disappeared. In this session, we’ll explore why managing performance is even more critical with Azure SQL DB and Azure Managed Instance.

Topics that will be discussed include:

• Identifying and monitoring key performance indicators that impact cost
• Understanding what auto-tuning really means and how it works
• Identifying performance issues and correctly sizing your database to avoid unnecessary costs

Speakers:

• Anat Dror, SQL Server and DB2 Domain Expert at Quest Software
• Tim Fritz, Database Technical Specialist and Market Strategist at Quest Software