You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Audit

SQL auditing and compliance

Meet SQL Server audit and compliance requirements for all instances across your enterprise

ApexSQL Audit header image
Features Resources Gallery Compliance Compare Roadmap Testimonials-->
Pricing Free trial
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 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

fancy
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

fancy
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

fancy
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

fancy
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

fancy
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

fancy
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

fancy
See next feature

User security

Assign different roles to specific users or groups to increase application and data security

fancy
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

fancy
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

fancy
See next feature

Threshold alerting

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

fancy
See next feature

Login auditing

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

fancy
See next feature

Security change auditing

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

fancy
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

fancy
See next feature

Ease of use

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

fancy
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

fancy
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

fancy
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

fancy
See next feature

Resources and support

Generating custom reports for a SQL Server audit trail Configuring database auditing with SQL Server audit software Overlooking SQL Server audit on multiple SQL Server instances Be alerted on specific events found in the SQL Server audit log Achieve tamper-proof database environment with SQL Server audit software Configure a SQL Server audit with the highest precision Receive email notifications on critical events to meet SQL Server audit specifications Investigate the complete history of audited events in a SQL Server audit log

How to configure before-after auditing in ApexSQL Audit

This video explains how to configure ApexSQL Audit to track before and after changes on insert, update and delete operations and how to investigate change details including who made them, how and when

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

ApexSQL Audit 2018 – Screen shot tour

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

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

How to install ApexSQL Audit

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

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

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

See more

Compliance

ApexSQL Idera®
SQL Server version
      SQL Server 2005 - 2017
SQL Server edition
      Express
      Standard
      Enterprise
Auditing
      Audited servers/databases overview
      Before-After data auditing
      Configuration and data filtering
      Configurable Trace Settings
      Customizable user privileges and roles
      Predefined regulation templates
      Sensitive data auditing
      Resillience for Log Write Failure
      Advanced filters
Repository
      Archiving
      Custom data purge and repository archiving 2019 R2
      Schedule archiving 2019 R2
      Tamper-evident
Alerting
      Custom alerts for auditing events
Reporting
      Custom reports
      Exporting
      Predefined regulation templates
      Scheduling
Features
      Central management UI
      Web console
Account management
      Application roles and privileged users
Other
      High performance Extended Events based auditing 2019 R3
      Remote access
      Custom parameterization of audited data values 2019 R3
Interface
      GUI themes
      High DPI and 4K resolution support
      Microsoft standard iconography, colors and other visual effects
Price (Qty)
      1 $1,699 $3,795
      2 $1,359 $3,795
      5 $1,189 $2,819
      10 $1,019 $2,385

ApexSQL Audit 2018.06

Idera® SQL Compliance Manager 5.5.1


Comparison was conducted on October 17, 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 R6 Released ApexSQL Audit 2019 R1 2019 Q1 ApexSQL Audit 2019 R2 2019 Q1 ApexSQL Audit 2019 R3 2019 Q2 ApexSQL Audit 2019 R4 2019 Q3
Reporting
Filter before-after events by column and value
Reports on accessed columns
Statistical reports
Auditing
Include Primary key value on before-after auditing
Bulk-inserts before-after auditing
High performance Extended Events based auditing
Audit parameter values
Custom parameterization of audited data values
Advanced filters
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
Data alerts
Alerts on historical data (aggregated alerts)
Custom threshold
Sensitive columns alerts
Other
SQL Server 2019 support
ApexSQL Audit 2018 R6 Released ApexSQL Audit 2019 R1 2019 Q1 ApexSQL Audit 2019 R2 2019 Q1 ApexSQL Audit 2019 R3 2019 Q2 ApexSQL Audit 2019 R4 2019 Q3

GDPR is here

  The ApexSQL compliance relief program is here to help  

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

20+

Contact us

Buy now

Save a bundle

ApexSQL Audit is included in ApexSQL DBA

All 13 ApexSQL DBA tools

Priority support

1 year free support and upgrades

New products added for free

Combined 70%+ savings

For only $800 more

Learn more

Software

What's supported

Requirements

Testimonials

Sales

Support plans

Renewals and upgrades

Licensing

Help

Technical support

Customer service

Resend keys

News

What's new

What's next

Blog

Free

Tools

Editions

Licenses

Company

Contact

About

Jobs

Gold Partner

© 2019 ApexSQL LLC   |   +1 (866) 665-5500   |   sales@apexsql.com   |   support@apexsql.com   |   Privacy