SQL Server 2016 improves theXEvent Linq readerscalability and performance.The XEvent UI in SQL Server Management Studio uses the XEvent Linq reader to process the events for display.Careful study of the XEvent Linq reader revealed opportunities for scalability and performance improvements.
Note:The XEvent Linq reader is .NET based and can be used by custom applications.
Various changes were made to the XEvent Linq provider logic to reduce context switching, memory allocations and other aspects.
The following are testing results of the XEvent reader.
‘It Just Runs Faster’– The SQL Server 2016 client component processes XEvent files 10x+ faster improving the responsiveness of the XEvent UI and reader capabilities.