From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

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

Database auditing strategies

Database auditing strategies - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial

Database auditing strategies

“

- Database performance can be tracked and monitored with a wide variety of tools in SQL Server. When it comes time to audit the performance of the system there are two features in particular that can help you get the big picture. One method is to use trace flags. These are switches that can quickly be turned on or off in order to modify behaviors or settings of the server. By doing so you can isolate errors and other behavioral anomalies in order to better understand where they're originating from. Trace flags are represented by a number so for instance if you turn on flag 205 that'll instruct the server to put an entry in the error log when a stored procedure is recompiled as a result of auto updating statistics. Trace flags can be applied at three different levels. Global, session and query. Global trace flags are set at the server level and affect every connection. Session flags only affect the specific connection to the server. And query flags only affect a specific query. Some…

Contents