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 requirements for your installation.…