Optimize query performance in Azure SQL

After completing this module, you will be able to:

• Generate and save execution plans
• Compare the different types of execution plans
• Understand how and why query plans are generated

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

After completing this module, you will be able to:

• Explore normal forms and how they affect database design
• Choose appropriate datatypes for your data
• Evaluate appropriate index types
• Investigate the value of data compression

• Introduction
• Describe types of query plans
• Explain estimated and actual query plans
• Identify problematic query plans
• Exercise: Identify issues with a database design
• Knowledge check
• Summary

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

• Introduction
• Describe normalization
• Choose appropriate data types
• Design indexes
• Describe data compression
• Knowledge check
• Summary