Auditing Events

  • Comments posted to this topic are about the item Auditing Events

  • I like having a theme day on the QotD to help raise awareness of the new features. thanks!

  • By default, the audit events are written to the audit target in an asynchronous fashion. Question was not posted properly I guess.

    Thanks.

  • 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!

  • Good question, thanks.

  • 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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • 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.

  • Thanks for the link, i appreciate that!

    Think great, be great!

  • 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!

  • 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);..."

  • bbop1322 (7/30/2010)


    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.

    Today's editorial asks this question: http://www.sqlservercentral.com/Forums/Topic961091-263-1.aspx

  • Excellent question. Thanks Steve.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • With all of these questions on auditing, Steve must be doing some research on auditing. Does this also mean that auditing is weighing pretty heavily on Steve's mind? You prepping for an audit Steve?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • LOL, no, no audit for me. I am working on an auditing presentation, and in research /testing, I built a bunch of questions and writing.

  • When and where for the preso?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply