Abstract
Extended Events are a lightweight monitoring system offered by SQL Server. Because the architecture uses so few system resources, they scale very well and allow you to monitor their instances, with minimal impact on user activity. They are also highly configurable, which gives you in your role as a DBA a wide range of options for capturing details from a very fine grain, such as page splits, to higher-level detail, such as CPU utilization. You can also correlate Extended Events with operating system data to provide a holistic picture when troubleshooting issues. The predecessor to Extended Events was SQL Trace, and its GUI, called Profiler. This is now deprecated for use with the Database Engine, and it is recommended that you only use it for tracing Analysis Service activity.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Peter A. Carter
About this chapter
Cite this chapter
Carter, P.A. (2019). Extended Events. In: Pro SQL Server 2019 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5089-1_19
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5089-1_19
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5088-4
Online ISBN: 978-1-4842-5089-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books