|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-monitor-and-troubleshoot-using-extended-events/
课程评论：没有评论
**SQL Server 监控与故障排除：Extended Events 课程总结** 本课程是关于如何使用 **Extended Events (扩展事件)** 来监控和故障排除 **SQL Server** 数据库的视频课程。 **课程核心内容：** * **现代化监控方式：** 课程将介绍如何使用 Extended Events 来监控 TB 级的大型 SQL Server 数据库，并强调这是比 SQL Server Profiler 和 SQL Agent 脚本更高效、资源消耗更低的现代监控方法。 * **Extended Events 的优势：** Extended Events 是 SQL Server 中一个轻量级且高度可配置的性能监控系统。 * **主要学习目标：** * 学习如何使用 Extended Events **实时捕获 SQL Server 中的错误**。 * 学习如何使用 Extended Events **捕获查询死锁 (Deadlocks)**。 * 学习如何 **通过邮件通知死锁信息**。 * 学习如何使用 Extended Events **捕获长时间运行的查询**。 * 学习如何使用 Extended Events **捕获阻塞进程 (Blocked Process)**。 * 学习如何使用 **自定义脚本捕获所有查询**。 * **附加内容：** 课程包含关于课程材料和视频中使用脚本的**奖励讲座**。 * **Extended Events 的作用：** Extended Events 是一个强大的事件处理框架，作为 SQL Server Profiler 的更具可扩展性和灵活性的替代方案。它可以捕获数据库引擎中的各种事件，用于性能监控、故障排除和审计等目的。 **课程承诺：** 课程祝贺学习者注册，并预祝学习顺利！
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 learnHow 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 ServerBonus lecture. About course material and scripts used in the videosExtended 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!!!
