SQL 2016 – It Just Runs Faster: XEvent Linq Reader

Moved from: bobsql.com


SQL Server 2016 improves the XEvent Linq reader scalability 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.



8000 Events/sec