Techniques can be used to troubleshoot, diagnose, and prevent SQL connection issues. Topics such as logging, troubleshooting, and resolving conflicts are covered in this course, which aligns with exam 70-473.
Learning Objectives
Troubleshooting SQL Databases
- start the course
- enable metrics and diagnostics logging using the Azure portal
- stream metrics and diagnostic logs into Log Analytics
- stream metrics and diagnostic logs into Event Hub
- stream metrics and diagnostic logs into Azure Storage
- troubleshoot transient errors
- troubleshoot persistent errors
- recognize common database connection errors
- recognize common database copy errors
- recognize common resource governance errors
- describe common errors related to creating and using elastics pools
- describe common errors that can be encountered when using SQL databases
Practice: Diagnosing SQL Databases
- troubleshoot SQL database issues