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

database auditing performance issues? Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 1:13 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Sunday, May 4, 2014 11:25 AM
Points: 176, Visits: 406
Can anyone explain me that do we get any performance issues when we implement database auditing on whole database. I googled but unfortunately I didn't find any good information. If someone could explain me that would be great. Thanks
Post #1352443
Posted Friday, August 31, 2012 5:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 6,370, Visits: 13,709
what exactly is it you want to audit?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1352724
Posted Friday, August 31, 2012 9:47 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Sunday, May 4, 2014 11:25 AM
Points: 176, Visits: 406
All the table level changes(insert,update,delete,select).
Post #1352931
Posted Friday, August 31, 2012 11:02 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,294, Visits: 9,480
And how have you implemented database auditing on the whole database? (there are at least a half-dozen different ways to do it)

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1352984
Posted Tuesday, September 4, 2012 7:37 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Sunday, May 4, 2014 11:25 AM
Points: 176, Visits: 406
Ok, this is the way 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

By, implementing this do I get any performance issues? My database is size is 30 GB..and has harddrive capacity of 200 GB.
Post #1353887
Posted Thursday, September 6, 2012 9:04 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Sunday, May 4, 2014 11:25 AM
Points: 176, Visits: 406
Any updates by anyone would be helpful...
Post #1355389
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse