December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
What’s New with SQL Server Profiler
The SQL Server 2012 Profiler is essentially the same as the SQL Server 2008 profiler. This is not surprising because many new features that were added in SQL Server 2005 and SQL Server 2008 addressed gaps identified in previous versions.
One surprising decision is that the SQL Server Profiler for Database Engine Trace Capture and Trace Replay has been placed on the deprecation list in SQL Server 2012. These features will be supported in the next version of SQL Server but will be removed in a later version. Microsoft has identified Extended Events as the replacement. Extended Events is a lightweight event-based infrastructure that is covered in more detail in Chapter 35, “Monitoring SQL Server Performance