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 7, 2012 9:01 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, October 20, 2014 12:57 PM
Points: 182, Visits: 423
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: 2 days ago @ 10:36 AM
Points: 317, Visits: 878
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: Monday, October 20, 2014 12:57 PM
Points: 182, Visits: 423
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