From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Determine sources for performance metrics

Determine sources for performance metrics

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Determine sources for performance metrics

“

- Welcome back. This is lesson 7.2: Determine sources for performance metrics. In the last video, we reviewed some of the tools that are available to help establish a performance baseline, covered them at a very high level. Here, we'll distinguish between what is available with Infrastructure as a Service and what is available with Platform as a Service and go into a little more detail. To start with Infrastructure as a Service, we talked about Extended Events. Extended Events is a lightweight performance monitoring feature that enables users to collect data to monitor and troubleshoot problems. Extended Events gives you an inside look into the internal operations of the database engine that are relevant for performance tuning. Query Store. The Query Store simplifies query performance troubleshooting by providing insights on query plan, fast choice, and performance. SQL Server Profiler, this is an interface to create and manage traces and analyze and replay trace results. Events are…

Contents