Performance and Audit Logout

  • I've been trying to diagnose some performance issues, I ran the SQL Profiler tool and upon review,I found that all the SQLs are executing within one second.

    However, I did find something strange. A event called Audit Logout is taking a very long time. I'm not aware what exactly this does, but it is taking up a lot of CPU time and accounting for large reads.

    First of all what is it? And Is it safe to disable it?

    Thanks

  • Check this 2 msdn link,

    http://msdn2.microsoft.com/en-US/library/ms175441.aspx

    http://msdn2.microsoft.com/en-US/library/ms176138.aspx

     

    Hope this helps,

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • Audit logout is a security event. It marks when someone disconnects from SQL Server. The time for Audit Logout is the total amount of time the connection existed. So if someone has been connected to your SQL Server for a long time, the number will be quite large. It's not an indication that there is a performance issue.

    K. Brian Kelley
    @kbriankelley

  • Bringing back this post from the dead.

    We are experiencing some very random slowness with one of our stored procedure executions from our web server. We wrote a dummy GUI program that calls our web service method and we're doing a profiler trace to see how long it takes.

    We are seeing our stored procedure execution time is about 15 seconds, but the Audit Logout (the ENTIRE connection for that SPID) is 60 seconds. What is going on in that remaining 45 seconds? Is there any way to track what the Audit Logout function is doing?

Viewing 4 posts - 1 through 3 (of 3 total)

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