Using Trace and Extended Events

Practice Labs Module
Time
1 hour 2 minutes
Difficulty
Intermediate

The "Using Trace and Extended Events" module provides you with the instructions and devices to develop your hands-on skills in the following topics: Working with SQL Server Profiler, Monitoring system activity using Extended Events.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Overview

Introduction

The Using Trace and Extended Events module provides you with the instructions and devices to develop your hands-on skills in the following topics.

  • Working with SQL Server Profiler
  • Monitoring system activity using Extended Events

Lab time: It will take approximately 60 minutes to complete this lab.

Exam Objectives

Three exam objectives are covered in this lab.

Create traces on an instance of the SQL Server database using TSQL stored procedures

  • Start an Extended Events session
  • Monitor system activity using Extended Events

Exercise 1 - Working with SQL Server Profiler

The SQL Server database engine provides a collection of data and events known as trace. SQL Server Profiler is a graphical user interface that you can use to create and manage traces. You can save the data and events in a trace file that can be used for troubleshooting database problems arising out of slow running queries or inefficient stored procedures.

In this exercise, you will learn to work with SQL Server Profiler.

Exercise 2 - Monitoring System Activity Using Extended Events

Extended Events help to understand the innermost operations of the database engine. It is a monitoring system that helps to analyze, create, modify, and view session data.

In this exercise, you will learn to work with Extended Events in SQL Server Management Studio.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.