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.
Describe Azure identity, access, and security
This module covers some of the authorization and authentication methods available with Azure.
Describe features and tools in Azure for governance and compliance
This module introduces you to tools that can help with governance and compliance within Azure.
There are no reviews yet.