Capturing Errors With Extended Events - SQL Server Mini Course!!!
Here we look at how to capture errors on SQL Server using Extended Events. Unlike the standard SQL Server error log, Extended Events provides with the ability to capture application, user, AlwaysOn and networking errors to name a few! It's a fantastic tool for proactively fixing and improving your SQL Server estate.
In this tutorial we cover
The difference between SQL Errors and Extended Events errors, and why both are beneficial.
How to filter Extended Events to display and log errors of a particular severity then group these by application, database and/or server name.
Understanding error severity and why we don't need to analyse errors with a severity of 10 or below
A really important one - how to setup the Extended Event
Just as important - how to analyse our results to make it work for us and improve our environment going forward.
Whats where in this video? See below for contents!
00:00 Introduction
01:08 Errors Extended Events Setup
03:05 Capture Live Errors
05:28 Analysing and Filtering Results
06:00 Filtering Out Errors
If you are having problems setting up Extended Events (XE) on your local server then I have other videos on the subject that may help. If not comment below and I will make a video on it, if not then the below Extended Events Quickstart guide should help from Microsoft
https://docs.microsoft.com/en-us/sql/...
