This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.
Moved from: bobsql.com
Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Quick XE Trace’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release.
Despite the deprecation of SQL Profiler several years ago, as well as various documents and blogs pointing out the older trace facilities shortcomings and performance impact on the SQL Server, SQL Profiler is still a top choice of SQL Server Developers and DBAs. The ‘quick’ ability kept surfacing as a reason for using SQL Profiler. The ‘quick’ part was defined as getting live data on the DBA’s or Developer’s screen with just a few clicks.
The new tree node (XE Profiler) provides that ‘quick’ ability. The ‘Quick XE Profiler’ displays live events using the simple ‘Launch Session’ menu selection. The templates capture common events and leverage XEvent enhanced view capabilities to display the event data.