Extended events engine integration for ApexSQL

  • extended events engine integration icon audit

    Boosted audit
  • extended events engine integration management

    Better EE management
  • extended events engine integration auditing processor

    Updated auditing processor

Project overview

Extended Events processing is an integral part of SQL audit. The basic EE engine must have in-depth functionality and be flexible in work in order to provide convenience and speed of Extended Events processing. Creating a new processor along with a parser, we also expanded the functionality of pre-existing EE engine elements to give the client an all-around efficient approach.

Client information

ApexSQL is a company focused on creating, distributing, and deploying SQL Server solutions. Currently owned by the renowned Quest (a top software and IT services provider in the niche), ApexSQL is working with some of the industry’s biggest partners, including Intel, Bank of America, and even NASA.

extended events engine integration project

Business challenge

The business workflow must be a fail-proof and error-free as possible to bring long-term, stable results. Extended Events processing is an advanced and very efficient way to indicate SQL Server errors and prevent them timely. That’s why we set out to expand the powers of ApexSQL’s existing EE engine.

Technical challenges

Management of Extended Events is among the major ways of efficiently troubleshooting any potential errors in the SQL Server’s performance. We needed to create a new processor and parser, as well as add changes to the existing elements. The main tasks were to create a configurable data-transfer mechanism, parser library able to convert EEs to CRD, and more.

Solution delivered

We created and integrated new Extended Events elements for the existing ApexSQL Audit library. New assemblies of DLL files and actors make for a powerful, reliable ExtnededEvents engine. The main ApexSql.Audit.ExtendedEvents.Processor element consists of the following actors:

  • EeProcessorManagerActor – a setup configuration class for Ssee libraries.
  • ExtendedEventsManagerActor – a class that governs initialization and management of Extended Events sessions.
  • ExtendedEventsCollectingActor – collects Extended Events files and filters data they hold.
  • PackageSendingActor – builds packages with Extended Events and sends them to central instances.
  • EventFilteringActor – filters events before processing based on the AuditingConfiguration.
extended events engine integration solution
Claim a 30-minute talk with our experts and get a step-by-step strategy for your project for free!

Key features

extended events engine integration key
  • ApexSql. Audit. ExtendedEvents. Processor

    A convenient processor that sets up the ApexSql.SseeEngine library based on the AuditConfiguration and allows managing collected XEL files. It is, basically, an assembly of the following actors:

  • ApexSql. Audit. ExtendedEvents. Parser

    A DLL assembly that converts EE data in the XEL format into the ApexSQLAudit format and passes data to store in the CRD format.

  • ApexSql. Audit. Processor. Central

    Allows working with configurations of auditing processor so that configurations are specified per server instance and converted into a simple, accessible form.

Value to our client

  • Boosted audit

    Auditing procedures and results become ultimately smoother and more fruitful when a truly powerful EE processor is at work.

  • Better EE management

    All the underlying Extended Events manipulations are now additionally automated and can be managed more diversely.

  • Updated auditing processor

    The existing auditing processor acts as the ultimate performance booster, allowing to eliminate issues more thoroughly.

Our tech stack

  • ch C#
  • Visual-Studio-1 Visual Studio
  • net .NET/ASP.NET

Software solutions bringing business values

6 reviews
47 reviews

    Contact us

    100% data privacy guarantee

    Thank you!
    Your request has been sent
    We will get back to you as soon as possible

    USA (Headquarters)

    +16469803276 2810 N Church St, Ste 94987, Wilmington, Delaware 19802-4447


    +4531562900 Copenhagen, 2900 Hellerup, Tuborg Havnepark 7


    +48789743438 ul. Księcia Witolda, nr 49, lok. 15,
    50-202 Wrocław


    +4366475535405 Vilnius, LT-09308,
    Konstitucijos ave.7
    6th floor

    Faroe Islands

    +298201515 Smærugøta 9A, FO-100 Tórshavn,
    Faroe Islands


    +4366475535405 Donau-City-Straße 11 - Ares Tower, 1220 Wien


    +4366475535405 Emarat Atrium, 423 Al Wasl Area, Dubai, P.O. Box 112344


    +4366475535405 Vatslava Havela Boulevard, 4,