O'Reilly logo

Pro SQL Server 2012 Administration by Sylvester Carstarphen, Ken Simmons

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

C H A P T E R  15

Extended Events Interface

Extended Events is an extremely flexible and low overhead event handling system that was introduced in SQL Server 2008. There is actually an event session called system_health that is configured to run by default in SQL Server 2008 that keeps track of information that was deemed useful by the Product Support team. The Extended Events infrastructure has been built from the ground up based on the premise that a diagnostic system should not prevent a user workload from running. Even if you do add too much overhead to the server by poorly configuring a session, the server should still be responsive enough to disable the session.

The flexibility offered by Extended Events also adds to the complexity of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required