Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.

Prerequisites

• Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
• Experience creating and configuring resources using the Azure portal
• Experience using Windows Performance Monitor to monitor system components such as CPU, I/O, network traffic
• Knowledge of purpose of SQL Server system databases: master, tempdb, msdb
• Basic understanding of SQL Server file storage
• Basic understanding of structure and usage of SQL Server indexes