SQL Server Monitor and Troubleshoot Using Extended Events

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

1. How to capture Real time Errors using Extended Events in SQL Server?

2. How to capture DeadLocks using Extended Events in SQL Server?

3. Notify Deadlock info to mail?

4. How to capture Long Running queries using Extended Events in SQL Server?

5. How to capture Blocked process using Extended Events in SQL Server?

6. Capture all queries using Custom Scripts in SQL Server

7. 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 !!!

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 0 votes
• 3 stars: 0 votes
• 4 stars: 0 votes
• 5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!