Quickstart into database Performance Monitoring & Troubleshooting

A consistent performance experience is crucial for a successful business. If you are developing, testing, or supporting SQL databases, you need to understand where to look and what to look for.
Depending on whether your SQL database is hosted on-prem, in Azure SQL or Fabric, there are some differences in what tools are available.
This session provides an overview of these tools, highlighting their overlaps and showing which techniques work across all platforms.
Among the things you will be introduced to will be Dynamic Management Views, Extended Events, and the Query Store. So next time someone asks you to take a look at a badly performing database application, you know where to look.

Learn valuable dynamic management views Learn about Extended Events and how to use the UI for analysis Learn which tools and techniques are available for which monitoring scope