Azure SQL Database Monitoring and Performance Tuning
Lecture
Paul Burpo
Advanced
4 h 42 m
2017-09-15
Lecture Overview
This course will be a deep dive into Azure SQL Database performance. We will look at designing an Azure SQL Database architecture for performance. We will look at performance specific features of Azure SQL Database. We will also cover monitoring and troubleshooting.

Related Learning Path(s):
Designing and Implementing Cloud and Data Platform Solutions - Exam 70-473
Azure SQL Database and SQL DW
Lecture Modules

Cover features used to handle database performance.

       Performance overview

       Understanding resource governance

       DTUs and service tiers



Cover features used to handle database performance.

       Indexing

       In-memory

       In-memory analytics

       Data load/export

Cover performance monitoring and tuning tools as well as advanced troubleshooting techniques.

       Performance monitoring

       Performance recommendations

       Automatic tuning

       Performance guidance

       Query Store

       Extended events

       Compatibility levels

       Monitor in-mem

Cover elastic database pools. Managing database performance in the pool. Using elastic database tools to manage the pool.

       Managing workloads across an elastic pool

       Special considerations for monitoring elastic pools

       Identifying elastic pool candidates

Try Risk Free
Start a free trial

Skill Me Up subscriptions include unlimited access to on-demand courses with live lab lab environments with our Real Time Labs feature for hands-on lab access.

Subscription Benefits
  • Access to Real Time Lab environments and lab guides
  • Course Completion Certificates when you pass assessments
  • MUCH MORE!