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

Performance and Audit Logout Expand / Collapse
Author
Message
Posted Sunday, May 7, 2006 6:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 1, 2008 1:37 PM
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

Post #278204
Posted Monday, May 8, 2006 7:28 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 13, 2013 8:04 PM
Points: 545, 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

Post #278267
Posted Tuesday, May 9, 2006 8:24 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, July 10, 2014 1:34 PM
Points: 6,623, Visits: 1,855
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
Post #278619
Posted Thursday, September 22, 2011 3:42 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 8, 2014 7:12 AM
Points: 263, Visits: 443
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?
Post #1179787
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse