SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Performance and Audit Logout


Performance and Audit Logout

Author
Message
Burt
Burt
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 3

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


Sameer Raval
Sameer Raval
SSChasing Mays
SSChasing Mays (634 reputation)SSChasing Mays (634 reputation)SSChasing Mays (634 reputation)SSChasing Mays (634 reputation)SSChasing Mays (634 reputation)SSChasing Mays (634 reputation)SSChasing Mays (634 reputation)SSChasing Mays (634 reputation)

Group: General Forum Members
Points: 634 Visits: 255

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
K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (10K reputation)

Group: Moderators
Points: 10180 Visits: 1917
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
andegre
andegre
SSC-Addicted
SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)

Group: General Forum Members
Points: 435 Visits: 460
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search