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.
Team composition
5 members
Client name
ApexSQL
Expertise used
Duration
5 months
Services provided
Custom software development, Software architecture, Manual testing, Automated testing, System integration services
Country
United States of America
Industry
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.
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.
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:
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:
A DLL assembly that converts EE data in the XEL format into the ApexSQLAudit format and passes data to store in the CRD format.
Allows working with configurations of auditing processor so that configurations are specified per server instance and converted into a simple, accessible form.
Software solutions bringing business values
