Lesson Learned #492: Improving Extended Events in Azure SQL
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:
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.
Real-Time Data Viewing: The ability to see event data in real time aids in immediate diagnostics and troubleshooting.
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.
Enhanced Diagnostics and Permissions: Improvements in diagnostics and permissions enable more effective problem resolution and greater control over event sessions.
Enjoy!
Microsoft Tech Community – Latest Blogs –Read More