SQL Server Monitor and Troubleshoot Using Extended Events

Name: SQL Server Monitor and Troubleshoot Using Extended Events
Rating: 4.2 (6 reviews)

Monitor the sql server using Extended Events is smart idea now a days with size of Terabyte databases

Created byRajasekhar Reddy Bolla

Last updated 12/2023

English

English [Auto],

What you'll learn

This video course helps. How do I monitor the terabyte databases of SQL Server using extended events?
Students learn, Modern techniques for SQL Server monitoring and troubleshooting
Students learn, how to quickly catch blockings, deadlocks, long-running queries, etc. in this course by utilizing extended events
Monitor the sql server using Extended Events is smart idea now a days

Course content

1 section • 7 lectures • 54m total length

Capture Erros using Extended Events in SQL Server7:45
Explore how extended events in SQL Server capture and view errors across databases, including application-side failures, with a lightweight, script-driven session for monitoring and troubleshooting.
Capture DeadLocks using Extended Events in SQL Server13:43
Learn to capture and analyze deadlocks in SQL Server using Extended Events, avoiding SQL profiler, with real-time deadlock capture, XML reports, and automation via SQL jobs.
Notify DeaddLock info using mail4:08
Learn to capture deadlock information with extended events. Configure a SQL agent job to email alerts when a deadlock occurs, using a T-SQL script and a specified deadlock path.
Capture LongRunning querues using ExtendedEvents in SQL Server6:44
Learn to capture long running queries in sql server using extended events, set thresholds, start sessions, and view sql text, batch text, and target data for production monitoring.
Capture Blocked process using Extended Events in SQL Server9:53
Learn to capture blocking sessions in SQL Server using extended events, configure a blocking process threshold, and interpret blocked process reports to diagnose and reduce blocking.
Capture all queries using Custom Scripts in SQL Server11:54
Capture all SQL queries 24/7 with a 30-second job that writes to a query stats table and moves older data to history, enabling root-cause analysis with an execution plan.
Bonus Lecture0:04

Requirements

This course is available to everyone who wants to learn about SQL Server and how to solve everyday problems.

Description

This video course helps. How do we monitor the terabyte databases of SQL Server using extended events. This is the modern way of monitoring of databases actually. Also, This way it wont consume much resources like profiler and custom scripts running through sql agent jobs. Extended Events is a lightweight and highly configurable performance monitoring system in Microsoft SQL Server

In this course you will learn

How to capture Real time Errors using Extended Events in SQL Server?
How to capture DeadLocks using Extended Events in SQL Server?
Notify Deadlock info to mail?
How to capture Long Running queries using Extended Events in SQL Server?
How to capture Blocked process using Extended Events in SQL Server?
Capture all queries using Custom Scripts in SQL Server
Bonus lecture. About course material and scripts used in the videos

Extended Events is a powerful event-handling framework that was introduced in SQL Server to provide a more scalable and flexible alternative to SQL Server Profiler. It allows you to capture a wide range of events that occur within the SQL Server database engine. Extended Events can be used for performance monitoring, troubleshooting, and auditing purposes and others.

Thanks for registering this course and Best of luck !!!

Who this course is for:

This course is designed for People who want Professionals seeking to enhance their skills in SQL Server