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.

 

Enjoy!

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.