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 12»»

Auditing Events Expand / Collapse
Author
Message
Posted Thursday, July 29, 2010 9:16 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item Auditing Events






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #961096
Posted Thursday, July 29, 2010 9:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
I like having a theme day on the QotD to help raise awareness of the new features. thanks!
Post #961097
Posted Thursday, July 29, 2010 11:57 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 3:08 AM
Points: 785, Visits: 1,259
By default, the audit events are written to the audit target in an asynchronous fashion. Question was not posted properly I guess.

Thanks.
Post #961147
Posted Friday, July 30, 2010 6:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:05 AM
Points: 1,222, Visits: 140
I got it wrong too but I'm not blaming the guy who asked the question!

I did some research after this to become more familiar with the subject matter. The question i have is that i can find no place to configure the synchronicity of the log writing. I now know where to create them at both the Server and Database level but cannot determine where to configure the synchronicity at. Can someone point me in the right direction?

On a side note, is anybody currently using this meet HIPAA standards? If so, would you care to share which audit policies you've put in place?

Thank you,

Brian


Think great, be great!
Post #961269
Posted Friday, July 30, 2010 6:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
Good question, thanks.
Post #961298
Posted Friday, July 30, 2010 7:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:24 PM
Points: 11,990, Visits: 11,007
Sourav-657741 (7/29/2010)
By default, the audit events are written to the audit target in an asynchronous fashion. Question was not posted properly I guess.


The term "default" should have been pretty obvious that it is a setting. This implies that you can change it. I would have to say that the problem was not in the question but in the reading of it.

Good question Steve.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #961362
Posted Friday, July 30, 2010 7:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:12 AM
Points: 1,247, Visits: 1,594
bbop1322 (7/30/2010)
... I now know where to create them at both the Server and Database level but cannot determine where to configure the synchronicity at. Can someone point me in the right direction?...


Brian, at http://msdn.microsoft.com/en-us/library/cc280448(SQL.100).aspx, it explains that setting the QUEUE_DELAY property to 0 causes the audit to run synchronously, anything higher causes it to run asynchronously. The default (and minimum non-zero value) is 1000 ms.
Post #961387
Posted Friday, July 30, 2010 7:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:05 AM
Points: 1,222, Visits: 140
Thanks for the link, i appreciate that!

Think great, be great!
Post #961393
Posted Friday, July 30, 2010 8:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:05 AM
Points: 1,222, Visits: 140
Now, if someone wants to share what types of Audits they have setup for HIPAA purposes i would be able to get that promotion, jk, but it would be helpful to know if i share the same thoughts as others on the topic.


Think great, be great!
Post #961394
Posted Friday, July 30, 2010 8:11 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
Sourav-657741 (7/29/2010)
By default, the audit events are written to the audit target in an asynchronous fashion. Question was not posted properly I guess.


The question was not asking about defaults, so I'm not sure what you mean here. The events can be written in an async or sync fashion, and that is configurable. From the white paper

"...The choice of asynchronous or synchronous is controlled by the QUEUE_DELAY option of the CREATE AUDIT DDL (explained below);..."







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #961409
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse