database auditing performance issues?

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 » database auditing performance issues?

database auditing performance issues?

Rate Topic

Display Mode

Topic Options

Author

Message

DBA_Learner

Posted Thursday, August 30, 2012 1:13 PM

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. I googled but unfortunately I didn't find any good information. If someone could explain me that would be great. Thanks

Post #1352443

Perry Whittle

Posted Friday, August 31, 2012 5:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:04 AM
Points: 5,242, Visits: 11,256

what exactly is it you want to audit?

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

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1352724

DBA_Learner

Posted Friday, August 31, 2012 9:47 AM

SSC-Enthusiastic

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

All the table level changes(insert,update,delete,select).

Post #1352931

RBarryYoung

Posted Friday, August 31, 2012 11:02 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

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

DBA_Learner

Posted Tuesday, September 04, 2012 7:37 AM

SSC-Enthusiastic

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

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

DBA_Learner

Posted Thursday, September 06, 2012 9:04 AM

SSC-Enthusiastic

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

Any updates by anyone would be helpful...

Post #1355389

« Prev Topic | Next Topic »

Permissions