The performance monitoring process requires an event handling system in addition to existing tools such as PERFMON, SQL Profiler, and DMVs. The design and testing of an application system will always have unanticipated problems that require extensive troubleshooting techniques. To avoid any sort of interruption to the performance monitoring, an event-handling system for the server is essential. SQL Server 2008 addresses this situation by providing Extended Events (XE). The XE infrastructure is a lightweight mechanism that supports capturing, filtering, and action on events generated by the server process.
The process of events and data are managed by the internal objects and it is ideal to mention the Extended Events concepts.
SQL Server Extended Events packages works as a container for XE objects such as package. The three kinds of XE packages are:
package 0(XE system objects),sqlserver, andsqlos.Every XE package contains objects such as:...