SQL Server Extended Events (Extended events)-Architecture

SQL Server Extended Event (Extended Events )--Architecture

Msdn:http://msdn.microsoft.com/zh-cn/library/bb630282%28v=sql.110%29.aspx

blog:http://blogs.msdn.com/b/extended_events/

SQL Server Extended events have a highly scalable and highly configurable architecture that enables users to gather the information they need to address performance issues or identify performance issues on demand. Extended events are lightweight performance monitoring systems that use very few performance resources.

Extended Event Architecture

The Extended events (Extended events) are general event-handling systems for server systems. The extended event infrastructure supports the association of data in SQL Server and, in some cases, the association of data in the operating system and database applications. In the latter case, the extended event output must be directed to Windows event Tracing (ETW) in order for the event data to be associated with the operating system or application event data.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;border-bottom:0px;border-left:0px; "alt = "image" src= "http://s3.51cto.com/wyfs02/M01/58/19/wKioL1SpExWwF1TlAAE49A0pDbM690.jpg" border= "0" height= "354"/ >

The extended event system features far more than any previous event tracking and troubleshooting mechanism provided by SQL Server. In my opinion, the extended event system has the following characteristics:

L events are triggered synchronously, but can be processed synchronously or asynchronously.

Any target can consume any event, and any action can be paired with any event, allowing more in-depth monitoring of the system.

The "smart" predicate allows you to use Boolean logic to construct complex rules.

L can use Transact-SQL to take full control of extended event sessions.

L can monitor performance-critical code without impacting performance.

This article is from the SQL Server deep dives blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1599085

SQL Server Extended Events (Extended events)-Architecture