Abstract
In this chapter we’ll look at the currently existing tracing and diagnostic infrastructure in SQL Server 2012. There are three areas we’ll cover: SQL Trace, Event Notifications, and Extended Events. SQL Trace is the oldest of the three and has been put on the deprecated features list in SQL Server 2012. This means that it will be removed from the SQL Server in a future version. Future version usually means current version + 2. Because of that I assume for this chapter that you’re familiar with the terminology and basic use of SQL Profiler. Event Notifications were introduced in SQL Server 2005 and are an asynchronous eventing system based on SQL Server Service Broker. The events that are sent can be database or server scoped. Extended Events were introduced in SQL Server 2008 and are a completely new diagnostic and tracing infrastructure built directly inside SQLOS.
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
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Bradley Ball, TJay Belt, Glenn Berry, Jes Borland, Carlos Bossy, Louis Davidson, Jeremy Lowell, Ben DeBow, Grant Fritchey, Wendy Pastrick, Kellyn Pot’vin, Jonathan Gardner, Jesper Johansen, Mladen Prajdić, Herve Roggero, Chris Shaw, Gail Shaw, Jason Strate
About this chapter
Cite this chapter
Prajdić, M. (2012). From SQL Trace to Extended Events. In: Pro SQL Server 2012 Practices. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4771-5_5
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4771-5_5
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4770-8
Online ISBN: 978-1-4302-4771-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books