You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
Audit all SQL database and security activities
Meet compliance requirements e.g. HIPAA, PCI
Out-of-the-box and custom Win and Web reporting
Securely store audit data in a tamper-evident repository
Fully customize all auditing, alerts, and reporting
Who, what, where, and when type auditing
Deploy on SQL Server Failover Clusters
Easily manage auditing on multiple servers

Features

Customizable auditing and compliance templates

Use existing out-of-the-box templates to configure SQL Server instance auditing and ensure that the auditing configuration includes all SQL Server and database level events required to meet HIPAA, SOX, PCI, FERPA and other compliance standards. Customize existing and create your own templates and apply them to multiple SQL Servers with a single click

See next feature

Who saw what, when and how

Identify, track and receive alerts when specific objects are accessed and data was viewed. Find out the name of the login, computer, and application used to access audited objects as well as the time of the event. Learn more

See next feature

Before-and-after auditing

Audit data changes from Insert, Update and Delete data operations. Investigate and compare original values to the new ones. Learn more

See next feature

Application and login level auditing

Audit operations executed by specific users, including high privilege users, or choose to perform full auditing of database changes from specific applications

See next feature

Customizable and out-of-the-box reports

Quickly review captured information by selecting from the large library of built-in reports. Create new, custom reports from any existing report

See next feature

No performance degradation

Minimal or negligible overhead is created when SQL Server events are being audited and processed into the central repository database

See next feature

Tamper-evident repository design

Automatically detect any changes or on the audited data, or auditing and alerting configurations. Receive alerts, in real time, based on any suspicious activities. Learn more

See next feature

Limited auditor's access

Allow read-only permissions to auditors or other specific users by using the standalone reporting application via a connection from any machine inside the domain to create full auditing reports. Run integrity checks or investigate alerts without having to allow other users access to auditing data or configuration options

See next feature

Maximum filter granularity and pinpoint precision

Use logical conditions and group them, per configuration requirement, to create high level or complex audit filter configurations, reports and even alerting with high precision and maximum granularity

See next feature

Custom alerting

Get notified and alerted in real time when important events occur on audited SQL Servers including critical auditing events and data changes or configuration updates. Utilize existing alerts or create custom ones. Write alerts to the windows event log or send via email. Learn more

See next feature

Threshold alerting

Utilize user-created scripts to check for important thresholds. Get alerted on any threshold breaches in real time

See next feature

Login auditing

See all successful or failed login attempts on audited SQL Server instances and view login access history. Learn more

See next feature

Security change auditing

Investigate any permission, SQL login, user, password, and role changes. Learn more

See next feature

SQL Server activity auditing

Audit all operations performed on your SQL instances including DML and DDL changes, select statements as well as login, user, and permission related activities. Learn more

See next feature

Ease of use

Quick and simple installation and configuration of auditing filters allows users to initiate high level auditing within minutes

See next feature

Automatic deployment of auditing components

Components are automatically installed and deployed to all machines that host SQL Server instances that are audited, removing the need for any additional manual installation or implementation tasks on user's side

See next feature

Advantages of ApexSQL Audit

This blog article provides an overview of some important ApexSQL Audit advantages over similar tools and gives insight in some unique features specific for ApexSQL Audit

ApexSQL Audit vs. SQL Server Change Data Capture (CDC)

This blog article provides detailed information on SQL Server auditing with bot ApexSQL Audit and SQL Server Change Data Capture (CDC) and showcases key advantages of ApexSQL Audit

Capturing who saw what in SQL Server

This article describes how to configure and quickly investigate audited results in order to find out who saw what, when and how, connection and access attempts and more

Before and after auditing in SQL Server

This Solution center article describes two different approaches and solutions to before and after auditing

Auditing SELECT statements on SQL Server

This article describes how to use ApexSQL Audit to capture all SELECT statements and discover who and when is accessing the data

An introduction to ApexSQL Audit

This video explains core features of ApexSQL Audit, and provides full info on events auditing and alerting, installation and architecture, as well as a quick setup guide

SQL Server database security auditing

This article provides detailed guide on how to configure ApexSQL Audit to track all security changes on SQL Server instances, on both server and database levels

SQL Server auditing – how to be alerted about important auditing events

This article describes how to configure ApexSQL Audit to alert DBAs or other users on important auditing events and send automatic email notifications on specific auditing events

Tracking SQL Server object usage

This article provides detailed guide on how to use ApexSQL Audit to track object usage in order to optimize schema or performance and ensure transparent security monitoring on object access

ApexSQL Audit installation guides

This article provides key information and links to all important ApexSQL Audit installation articles

ApexSQL Audit 2017 – Screen shot tour

This article represents a screen shot tour of ApexSQL Audit features with a brief description

See more

Roadmap

Before and after auditing

Show full audit trail including data as it existed before and after a change

Advanced archive

Choose to archive from specific time: last week, last month, last year or just by specific date

Improved reports

Export reports using CLI. Generate reports from multiple simultaneous data sources.

See our entire roadmap

The roadmap does not show maint only releases


ApexSQL Audit 2016 R2 Released ApexSQL Audit 2017 R1 Released ApexSQL Audit 2017 R5 Released ApexSQL Audit 2018 R1 Q4 ApexSQL Audit 2018 R2 Q1
Reporting
Custom reports in GUI
Multiple simultaneous data sources
Predefined reports for HIPAA, SOX, FDA and PCI standards
Dedicated before-after report
Scheduler for exporting reports and data collection
Relative date filter
Filter before-after events by column and value
Statistical reports
Reports on accessed columns
Auditing
CLR trigger based Before-and-after auditing
Database encryption for before-after data
Saving filter configuration to file system
Custom trace file size
Custom package file size
Advanced Filter
Filter templates
The 'starts with' and 'ends with' operators
The 'is Null' and 'is not NULL' operators
Include/Exclude query text
Simple filter
Choose table columns (sensitive columns)
Statistics & Status
Advanced system status
Detailed info about each auditing instance
Detailed info about central instance
Aggregate preview on collected data per system and per instance
Graphical preview on collected data per system and per instance
Health information - diagnostic window, allows detecting system wide issues and suggest possible solutions
Archiving & Purging
Choose to archive from specific time: last week, last month, last year or just by specific date
Purge data from specific time range
Remove or backup database on uninstall
Data integrity
Option to ignore specific detected tampering
Alerting
Notification editor (highlight and insert variables)
Windows event log entry
E-mail recipient list
Import/export alert rules
Data alerts
Alerts on historical data (aggregated alerts)
Custom threshold
Sensitive columns alerts
General
Automatic auditing instance deployment
Support for SQL Server 2017
AlwaysOn cluster support
Extended Events based auditing
ApexSQL Audit 2016 R2 Released ApexSQL Audit 2017 R1 Released ApexSQL Audit 2017 R5 Released ApexSQL Audit 2018 R1 Q4 ApexSQL Audit 2018 R2 Q1

Testimonials

A word of congratulations. I think that your suite is some of the best stuff I have ever used. I had to add auditing to an existing SQL Server and your ApexSQL Audit product did that effortlessly and flawlessly. The client loves the solution I am also impressed by your rapid response to issues and feedback. Keep up the good work

Cameron Townshend

Executive Consultant

ISG Technology

One of the problems with so many tools on the market today, to accomplish audit and compliance, is the complexity of use. ApexSQL Audit is straightforward and easy to configure, I was able to set-up our audit and compliance in minimal time using this tool.

Gary Fry

Senior Database Administrator

Cox Industries, Inc.

ApexSQL Audit is great. This product will allow me to show non-technical users audit trails for SELECT, INSERT, and UPDATE statements in a graphical manner that I can explain quickly.

Robert R.

Macro Integration Services

Implementation Specialist

Volume pricing

per instance

1

$1,699

2-4

$1,359

5-9

$1,189

10-19

$1,019

Save a bundle

ApexSQL Audit is included in ApexSQL DBA

9 ApexSQL DBA tools

Priority support

1 year free support and upgrades

New products added for free

Combined 70% savings

For only $800 more