Extended events were introduced by Microsoft in SQL Server 2008, and have been refined and improved through SQL Server 2008R2 and SQL Server 2012 into a full replacement for SQL Trace and Profiler. It is now a lightweight flexible platform that lets you drill down into what is happening under the covers of SQL Sever. You can use it to identify performance issues, or to examine in minute detail how proposed solutions will work, or to find bad practices in your application.
And with Microsoft’s announcement in SQL Server 2012 of the deprecation of SQL Trace and Profiler it means they will be completely removed in a later release, so now is the time to start learning to use the new tools and migrating existing procedure across.
The course is available in 3 formats:
- A 2 hour introductory session. This is predominantly presentation based, with some