Monitor and optimize operational resources in Azure SQL
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
User Reviews
Be the first to review “Monitor and optimize operational resources in Azure SQL”
Related Products
Microsoft Azure Fundamentals: Describe Azure architecture and services
New to the cloud? Microsoft Azure fundamentals is a three-part series that teaches you basic cloud concepts, provides a streamlined overview of many Azure services, and guides you with hands-on exercises to deploy your very first services for free. Complete all of the learning paths in the series if you are preparing for Exam AZ-900: Microsoft Azure Fundamentals. This is the second learning path in the series, Azure Fundamentals: Describe Azure architecture and services. The other learning paths in the series are Part 1: Describe cloud concepts and Part 3: Describe Azure management and governance.
Explore the possibilities with Copilot for Microsoft 365
This module explores the practical usage of Microsoft 365 Copilot across Microsoft 365 Apps, demonstrating how to streamline workflow and increase productivity.
Describe cost management in Azure
This module explores methods to estimate, track, and manage costs in Azure.
Microsoft Azure Fundamentals: Describe cloud concepts
New to the cloud? Microsoft Azure fundamentals is a three-part series that teaches you basic cloud concepts, provides a streamlined overview of many Azure services, and guides you with hands-on exercises to deploy your very first services for free. Complete all of the learning paths in the series if you are preparing for Exam AZ-900: Microsoft Azure Fundamentals. This is the first learning path in the series, Microsoft Azure Fundamentals: Describe cloud concepts. The other learning paths in the series are Part 2: Describe Azure architecture and services and Part 3: Describe Azure management and governance.
Introduction to Azure Cloud Shell
Describe Microsoft Azure Cloud Shell, learn how it works, and explore basic steps for its usage.
Configure user and group accounts
Learn how to configure user and group accounts.
There are no reviews yet.