Sunday, February 19, 2012

Analyzing SQL Profiler trace

Hi All,

I am going over the output of a Profiler trace and I've found that the duration for many occurrences of EventClass 15 (Logout) is several seconds, up to a maximum of 20 seconds. That seems excessive just to complete a logout, so my question is, does the duration figure reflect only the time to complete the logout operation or does it include the total time that the connection has been active for?

Thanks in advance
LempsterLook up "Security Audit Data Columns" in BOL. For The logout event, the duration is the approximate time the connection was in existence.|||are you sure that is not milliseconds you are looking at?|||No, definitely seconds (20,000-odd milliseconds), but McCrowley's explanation makes sense - thanks!
:)

No comments:

Post a Comment