Skip to content

Latest commit

 

History

History
46 lines (29 loc) · 2.47 KB

Challenge-05.md

File metadata and controls

46 lines (29 loc) · 2.47 KB

Challenge 05 - Monitoring Workload

< Previous Challenge - Home

Pre-requisites

  • You have to complete Challenge 04 - Partitioned table and Clustered Columnstore Indexes

Introduction

In this challenge you will understand how to monitor your workload to identify poor performing and failed queries using T-SQL DMVs and Azure Monitor

You can find all the files for this challnge into the Zip file provided by your coach at this path: ./Resources/Challenge-05/

Description

Learning objectives:

  • How to monitor workload with T-SQL DMVs
  • Store and query historical data using Azure Monitor

Monitor Dedicated SQL pool using T-SQL

Create a set of T-SQL commands to get information about:

  • Top 10 Slowest queries and their steps
  • Errors occurred during the last 24 hours
  • Tables size

Monitor Dedicated SQL pool using Log Analytic - Diagnostics

  • Configure Log Analytics and activate Diagnostic logs for [queries], [steps] and [waits] for your Dedicated SQL pool
  • Configure Diagnostic settings and configure data retention to ensure at least 2 months for delayed troubleshooting.

Success Criteria

  • Understand how DMVs works in Dedicated Sql pool and their persistence.
  • Being able to leverage Log Analytics to export DMVs data and store them for more than 1 month for delayed troubleshooting.

Learning Resources