This course focuses on maximizing the performance of hardware and infrastructure relating to database servers. You will learn the best ways to improve an SQL server's performance and that of its databases through infrastructure choice and configuration settings.
Learning Objectives
Learn how to set up disks for maximum performance
Understand how to boost file performance and how to use instant file initialization
Understand how to optimize TempDB and choose the right VM for your workloads
Learn how to manage an instance's resources
Learn how to configure your database as well as your SQL Server system accounts
Understand how to use Intelligent Query Processing to optimize database performance
Understand the benefits of using Azure SQL Serverless
Intended Audience
Database administrators
Solutions architects
Anyone interesting in improving the performance of their database
Prerequisites
To the most out of this course, you will need to be familiar with basic Azure concepts, have some knowledge of computer hard drives and networking, and be familiar with databases and their servers.