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
ApexSQL Idera®
SQL Server version
      2005-2016
      2017
SQL Server edition
      Express
      Standard
      Enterprise
Interface
      Central management UI
      High performance Extended Events based auditing 2018 R6
      Remote access
      Custom parameterization of audited data values 2018 R6
      GUI themes
      High DPI and 4K resolution support
      Microsoft standard iconography, colors and other visual effects
      Web console
Auditing
      Audited servers/databases overview
      Before-After data auditing
      Configuration and data filtering
      Configurable Trace Settings
      Customizable user privileges and roles 2018 R4
      Predefined regulation templates
      Sensitive data auditing
      Advanced filters
      Resillience for Log Write Failure
Repository
      Archiving
      Custom data purge and repository archiving 2018 R5
      Schedule archiving 2018 R6
      Tamper-evident
Alerting
      Custom alerts for auditing events
Reporting
      Custom reports
      Exporting
      Predefined regulation templates
      Scheduling
Price
$1,699 $2,277

ApexSQL Audit 2018.02

Idera® SQL Compliance Manager 5.4.2.468


Comparison was conducted on April 12, 2018

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates

Roadmap

Custom data purge

Safely remove old audited data from the repository database for custom time periods

Advanced archive

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

User management

Assign administrator, power-user or reader privileges to different ApexSQL Audit users

See our entire roadmap

The roadmap does not show maint only releases


ApexSQL Audit 2018 R1 Released ApexSQL Audit 2018 R4 Q3 ApexSQL Audit 2018 R5 Q4 ApexSQL Audit 2018 R6 2019 Q1 ApexSQL Audit 2018 R7 2019 Q2
Reporting
Relative date filter
Filter before-after events by column and value
Reports on accessed columns
Statistical reports
Auditing
Customizable user privileges and roles
High performance Extended Events based auditing
Custom parameterization of audited data values
Advanced Filter
Include/exclude query text filters
The 'is NULL' and 'is not NULL' operators
The 'starts with' and 'ends with' operators
Custom package file size
Simple filter
Choose table columns (sensitive columns)
Statistics & Status
Advanced system status
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
Inactive repository system alerts
Data alerts
Alerts on historical data (aggregated alerts)
Custom threshold
Sensitive columns alerts
General
Multi-client support
ApexSQL Audit 2018 R1 Released ApexSQL Audit 2018 R4 Q3 ApexSQL Audit 2018 R5 Q4 ApexSQL Audit 2018 R6 2019 Q1 ApexSQL Audit 2018 R7 2019 Q2

GDPR is here

  Get onboard with ApexSQL 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