August 30, 2012 at 1:13 pm
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
August 31, 2012 at 5:39 am
what exactly is it you want to audit?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2012 at 9:47 am
All the table level changes(insert,update,delete,select).
August 31, 2012 at 11:02 am
And how have you implemented database auditing on the whole database? (there are at least a half-dozen different ways to do it)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 4, 2012 at 7:37 am
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.
September 6, 2012 at 9:04 am
Any updates by anyone would be helpful...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply