You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 
Audit all SQL database and security activities
Meet compliance requirements e.g. HIPAA, GDPR, PCI
Out-of-the-box and custom reporting
Securely store audit data in a tamper-evident repository
Fully customize all auditing, alerts, and reporting
Who, what, where, when when and before-after 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 templates or create your own and apply them to multiple SQL Servers with a single click

See next feature

Who, what, when and how auditing

Identify, track and receive alerts when specific objects are accessed or 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 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 a library of built-in reports. Create new, custom reports from any existing report

See next feature

Low overhead

Minimal or negligible impact on performance while 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 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

High filter granularity and precision

Use logical conditions and group them, per configuration requirement, to create 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 custom 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 or role changes. Learn more

See next feature

SQL Server activity auditing

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

See next feature

Ease of use

Quickly install and configure auditing filters to setup an auditing plan in minutes

See next feature

Automatic deployment

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

Audit data archiving

Archive data without interrupting ongoing auditing. Choose the frequency, detach and transfer old repositories to storage safely and easily. Restore old repositories to read archived audited data

See next feature

Automatic reporting

Schedule report generation on a desired frequency. Have your daily, weekly or monthly reports automatically created and available per pre-defined schedules

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

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

How to configure ApexSQL Audit for security auditing

This video explains how to configure ApexSQL Audit, a SQL Server auditing and compliance tool, to audit all security related events on both SQL 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

How to install ApexSQL Audit

This video provides an explanation of ApexSQL Audit components and guides users through the different installation scenarios

ApexSQL Audit 2018 – 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 2017 R1 Released ApexSQL Audit 2017 R5 Released ApexSQL Audit 2018 R1 Released ApexSQL Audit 2018 R3 Q2 ApexSQL Audit 2018 R4 Q3 ApexSQL Audit 2018 R5 Q4 ApexSQL Audit 2018 R6 Q4
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
Reports on accessed columns
Statistical reports
Auditing
CLR trigger based Before-and-after auditing
Database encryption for before-after data
Saving filter configuration to file system
Custom package file size
Advanced Filter
Filter templates
Include/exclude query text filters
The 'is NULL' and 'is not NULL' operators
The 'starts with' and 'ends with' operators
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
Merge repository archives
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
Schedule archiving
Data integrity
Option to ignore specific detected tampering
Alerting
E-mail recipient list
Import/export alert rules
Notification editor (highlight and insert variables)
Windows event log entry
Inactive repository system alerts
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
Multi-client support
Extended Events based auditing
ApexSQL Audit 2017 R1 Released ApexSQL Audit 2017 R5 Released ApexSQL Audit 2018 R1 Released ApexSQL Audit 2018 R3 Q2 ApexSQL Audit 2018 R4 Q3 ApexSQL Audit 2018 R5 Q4 ApexSQL Audit 2018 R6 Q4

: :
Days Hours Minutes

  ApexSQL GDPR compliance relief program  

Learn more

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

11 ApexSQL DBA tools

Priority support

1 year free support and upgrades

New products added for free

Combined 70% savings

For only $800 more