From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Configure server settings for performance

Configure server settings for performance

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Configure server settings for performance

“

- Welcome back. This is lesson 9.5, configure server settings for performance. We'll start with Azure SQL Managed Instance. With Azure SQL Managed Instance, you don't have access to the physical hardware, but you can choose the service tier as well as the hardware generation. So with the Service Tier, you pick the number of vCores and storage amount, then pick the hardware you want to run it on. The hardware generation defines the compute and memory limits and other characteristics that impact the performance of the workload. Pretty simple. Let's move on to SQL Server in a virtual machine. So for SQL server and a virtual machine, there are a few things you can configure for performance. Let's start with the server itself. So the size, way back in lesson 2.3, we discussed the different virtual machine sizes and the impact they have on performance, ranging from the memory optimized M series and the memory optimized and storage optimized E Series. Both of these let you pick the amount of…

Contents