Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Performance and Audit Logout


Performance and Audit Logout

Author
Message
Burt
Burt
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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
Mr or Mrs. 500
Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)Mr or Mrs. 500 (546 reputation)

Group: General Forum Members
Points: 546 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 (6.8K reputation)

Group: Moderators
Points: 6770 Visits: 1908
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
andegre
andegre
SSC Veteran
SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)

Group: General Forum Members
Points: 289 Visits: 458
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