Lesson Learned #492: Improving Extended Events in Azure SQL

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

In the last months, our Product Team has been working to enhance Extended Events for Azure SQL as you could see in their blog: Improving Extended Events in Azure SQL - Microsoft Community Hub. These updates simplify monitoring and troubleshooting Azure SQL databases, offering a more SQL Server-like experience and enabling more granular control over events and sessions. 


These improvements include:


  1. Direct Event Data Visualization in SSMS: Users can now view event data directly in SQL Server Management Studio (SSMS) without downloading files, streamlining the monitoring process.

  2. Real-Time Data Viewing: The ability to see event data in real time aids in immediate diagnostics and troubleshooting.

  3. XEvent Profiler and Histogram Targets: The inclusion of XEvent Profiler provides a simplified way to monitor and analyze workloads, while histogram targets offer better insights into event data distributions.

  4. Enhanced Diagnostics and Permissions: Improvements in diagnostics and permissions enable more effective problem resolution and greater control over event sessions.



Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.