Start of main content
Extended events: helping developers solve problems on MS SQL production server
Any high-loaded system sooner or later faces a performance problem at the database level, caused by suboptimally written queries or the specifics of the ORM. Often there are short-term but significant slumps. One way to diagnose it is obviously logging the database events. Conventional methods (profiler and manual logging on triggers) behave badly under production load. MS SQL Server has a mechanism that logs everything and is quite safe. Through Extended Events we have learned to evaluate the performance of both Entity Framework generated code and stored procedures. We can also easily track input parameters that cause various errors on the database side.