SQL Profiler: Audit Logout

Q:
A developer reported very high duration times for the SQL Profiler “Audit Logout” event in his development environment, and inquired how to decrease this time.

A:
When a connection disconnects from SQL Server, “Audit Logout” reports the duration the entire connection existed. If the connection was open for a long time, this number can be quite large. It’s not indicative of any real performance issue, but is often times confused with one due to the large duration time.

Advertisement