September 2017
Intermediate to advanced
802 pages
37h 6m
English
SQL Server Profiler is supported in SQL Server 2016 but is now a deprecated feature for the relational database engine, and Extended Events is its long term replacement. Profiler is not a deprecated feature for Analysis Services, although a graphical interface to Extended Events is a new feature in SSAS 2016 and several new SSAS trace events are exclusively available via Extended Events. Regardless of the database engine (relational or analytical) Extended Events is more efficient and flexible than SQL Server Profiler, thus allowing for more nuanced event data collection with less impact on production workloads. Events associated with new SQL Server features are exclusive to Extended Events.
Read now
Unlock full access