MEAPSA

Evaluate performance improvements

Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore relevant Dynamic Management Objects.

Data Analyst

Database Administrator

Data Engineer

SQL Server

SQL Database

Module Objectives

After completing this module, you will be able to:

Explore Dynamic Manage Objects to extract query performance information
Determine when changing indexes or defining new ones can affect performance
Evaluate wait statistics as an aid in finding areas for performance improvement

Units

Introduction min
Describe dynamic management views and functions min
Describe wait statistics min
Tune indexes min
Maintain indexes min
Exercise: Isolate problem areas in poorly performing queries in a SQL Database min
Knowledge check min
Summary min

Prerequisites

Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Basic understanding of structure and usage of SQL Server indexes.
Basic understanding of relational database concepts.