From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Record extended event sessions - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Record extended event sessions
- [Narrator] Extended events is a system for collecting information about SQL Server instances and the databases that they contain. The graphical interface allows you to specify exactly how much data you want to collect and on what types of events. This lets you target specific issues and collect data about how the database reacts to different situations. To begin using extended events, we need to first create a new session. We can do that by going over to the object explorer, opening up the management folder, and then coming down to extended events. I'll open that up and we'll find the folder for sessions. And inside of there are all the sessions that are currently running on my machine. To create a new one, right click on the sessions folder and choose new session. That'll load up the new session dialogue box and we can fill in some of the parameters. First, we're going to supply a session name. I'll call mine…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.