From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Auditing the database

Auditing the database - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Auditing the database

- [Narrator] Partly performance, and partly security related, auditing a database provides insight into how the database is performing, but also how users are interacting with the database. Oftentimes there may be government or other regulatory requirements for audits on a database, which makes this an important topic. Auditing an instance of SQL Server, the database engine, or an individual database involves tracking and logging events that occur on the database engine. SQL Server lets you create audits at the server level, and at the database level. And they can contain server audit specifications for server-level events and database audit specifications for database-level events. They track and log events either to files, or to the security or application logs on the Windows operating system. So they can be written to either event logs or to files. There are several types of auditing or several levels of auditing for SQL Server depending on the government, or regulatory standard…

Contents