| In older version of SQL there are lot of tracing and troubleshooting mechanisms like DBCC, SQL Trace, Profiler. But these techniques are not able to do deep levels of tracing and troubleshooting for example page splits and high CPU utilization.
To overcome this Extended Events or XEvent comes in to picture. Its a latest version of tracing in SQL SERVER 2008 which provide a generic tracing and troubleshooting in framework which allows us to do deeper and more granular level of tracing which was not feasible in DBCC, SQL Trace, Profiler, etc. XEvent have more events then the SQL Trace. | | |