Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Auditing database performance impact Expand / Collapse
Author
Message
Posted Friday, September 07, 2012 9:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 9:34 AM
Points: 174, Visits: 403
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
Posted Monday, September 17, 2012 12:19 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 10, 2014 8:28 AM
Points: 316, Visits: 852
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
Posted Monday, September 17, 2012 1:59 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 9:34 AM
Points: 174, Visits: 403
Thanks for good post..That is whay I would like to go for SQL Server side tracing..
Post #1360439
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse