Chapter 42
SQL Audit
In This Chapter
Configuring SQL Audit
Tracking Server Events
SQL Audit was first introduced with SQL Server 2008. With the release of SQL Server 2012, several new and enhanced features to SQL Audit are available. This chapter explains what SQL Audit is and how to start using it, and points out the new features and updates from SQL Server 2008 to 2012.
SQL Audit is based on Extended Events technology; SQL Audit is both lightweight and powerful. Although you can create your own auditing solution from Extended Events, SQL Audit is an out-of-the-box solution to leverage Extended Events and collect server and database events. It is fast and easy to configure.
Although Extended Events is available for all editions of SQL Server 2008, SQL Audit is available only for the Enterprise (and Developer) Edition. Beginning with SQL Server 2012, server auditing is available for all editions of SQL Server; however, database audits are limited to Enterprise, Datacenter, Developer, and Evaluation editions.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
