Use the SQL Server Query Tuning Assistant
|
Learn how the Query Tuning Assistant (QTA) works alongside the Query Store to compare query performance statistics and find queries that are regressing due to changing compatibility levels.
Evaluate query tuning solutions like the QTA and automatic plan correction., Learn how to use the Query Store to assess query performance., Understand how the QTA works to address regressing queries., Learn how to use the QTA to maintain query performance after database upgrade.
Prerequisites
Knowledge of SQL Server database properties and options
Experience with using SQL Server Management Studio (SSMS) or executing SQL queries
Understanding of query plans, query tuning, and performance optimization
User Reviews
Be the first to review “Use the SQL Server Query Tuning Assistant”
Related Products
Describe Azure storage services
This module introduces you to storage in Azure, including things such as different types of storage and how a distributed infrastructure can make your data more resilient.
AZ-104: Prerequisites for Azure administrators
Learn the basic Azure concepts you need to know as an Azure administrator. Here are the learning paths in the AZ-104 Azure Administrator series:
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 cloud computing
This module introduces you to cloud computing. It covers things such as cloud concepts, deployment models, and understanding shared responsibility in the cloud.
Describe Azure identity, access, and security
This module covers some of the authorization and authentication methods available with Azure.
What is Microsoft 365?
Learn about Microsoft 365, the productivity cloud designed to help each of us achieve what matters, in our work and life, with best-in-class Office apps, intelligent cloud services, and advanced security.
There are no reviews yet.