Auditing database performance impact

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Auditing database performance impact

Auditing database performance impact

Rate Topic

Display Mode

Topic Options

Author

Message

DBA_Learner

Posted Friday, September 07, 2012 9:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:37 PM
Points: 170, Visits: 388

Can anyone explain me that do we get any performance issues when we implement database auditing on whole database. This database is used very limitedly though..but still I want to know by auditing
in this format, do we get any performance impact on database or not
I am implementing auditing : SCHEMA LEVEL AUDITING

CREATE DATABASE AUDIT SPECIFICATION Example2
FOR SERVER AUDIT ADEVNTUREWORKSAudit
ADD (INSERT,UPDATE,DELETE,SELECT
ON SCHEMA::dbo
BY public)
WITH (STATE = ON)
GO
If someone could explain me that would be great. Thanks

Post #1356043

Colleen M. Morrow

Posted Monday, September 17, 2012 12:19 PM

Old Hand

Group: General Forum Members
Last Login: Sunday, April 14, 2013 8:05 AM
Points: 300, Visits: 818

Linchi Shea did some great analysis on this very question.

The performance impact of SQL 2008 R2 Audit and SQL Trace

He also did a 3-part series on the perils of using synchronous auditing in SQL Audit. Well worth a read.

Part 1
Part 2
Part 3

Hope these help.

Colleen M. Morrow
Cleveland DBA

Post #1360392

DBA_Learner

Posted Monday, September 17, 2012 1:59 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:37 PM
Points: 170, Visits: 388

Thanks for good post..That is whay I would like to go for SQL Server side tracing..

Post #1360439

« Prev Topic | Next Topic »

Permissions