SQL Server Management Studio Provides–“XE Profiler”

Published Feb 23 2022 07:11 AM 484 Views
Microsoft

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.

%3CLINGO-SUB%20id%3D%22lingo-sub-3204527%22%20slang%3D%22en-US%22%3ESQL%20Server%20Management%20Studio%20Provides%E2%80%93%E2%80%9CXE%20Profiler%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3204527%22%20slang%3D%22en-US%22%3E%3CP%3EMoved%20from%3A%20bobsql.com%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBob%20Ward%20and%20I%20worked%20with%20our%20SQL%20Server%20Tool%20developers%20(thanks%20David)%20to%20enable%20%E2%80%98Q%3CEM%3Euick%20XE%20Trace%3C%2FEM%3E%E2%80%99%20capabilities.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EThe%20feature%20is%20available%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fssms%2Fdownload-sql-server-management-studio-ssms%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Elatest%20SQL%20Server%20Management%20Studio%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E(SSMS)%20release.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDespite%20the%20deprecation%20of%20SQL%20Profiler%20several%20years%20ago%2C%20as%20well%20as%20various%20documents%20and%20blogs%20pointing%20out%20the%20older%20trace%20facilities%20shortcomings%20and%20performance%20impact%20on%20the%20SQL%20Server%2C%20SQL%20Profiler%20is%20still%20a%20top%20choice%20of%20SQL%20Server%20Developers%20and%20DBAs.%26nbsp%3B%20The%20%E2%80%98quick%E2%80%99%20ability%20kept%20surfacing%20as%20a%20reason%20for%20using%20SQL%20Profiler.%26nbsp%3B%26nbsp%3B%20The%20%E2%80%98quick%E2%80%99%20part%20was%20defined%20as%20getting%20live%20data%20on%20the%20DBA%E2%80%99s%20or%20Developer%E2%80%99s%20screen%20with%20just%20a%20few%20clicks.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20new%20tree%20node%20(%3CSTRONG%3EXE%20Profiler%3C%2FSTRONG%3E)%20provides%20that%20%E2%80%98quick%E2%80%99%20ability.%26nbsp%3B%26nbsp%3B%20The%20%E2%80%98Quick%20XE%20Profiler%E2%80%99%20displays%20live%20events%20using%20the%20simple%20%E2%80%98Launch%20Session%E2%80%99%20menu%20selection.%26nbsp%3B%20The%20templates%20capture%20common%20events%20and%20leverage%20XEvent%20enhanced%20view%20capabilities%20to%20display%20the%20event%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3204527%22%20slang%3D%22en-US%22%3E%3CH3%20class%3D%22single-title%22%20id%3D%22toc-hId--1409655302%22%3ESQL%20Server%20Management%20Studio%20Provides%E2%80%93%E2%80%9CXE%20Profiler%E2%80%9D%3C%2FH3%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3204527%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBobSQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Feb 23 2022 07:11 AM
Updated by: