Post reply

Report Server resources during Audit Logout

  • January 3, 2006 at 4:27 pm

    #166660

    Hello there,

    I was reviewing a slow web app that has reporting services as a component of it.

    I ran sql profiler and I noticed that one of the longer steps was 570013 (milliseconds I believe).

    The "EventClass" for this line in the trace file was "Audit Logout"

    The ApplicationName = "Report Server".

    CPU = 15

    Reads = 1517

    Duration = 570013.

    Does anyone know what is happening here and if this amount of time is expected?

    Thanks.

    Greg

  • January 4, 2006 at 10:30 am

    #612670

    Greg,

    The duration reported for the Audit Logout event is the elapsed time for the associated connection, from login to logout, reported in milliseconds.

    So, it's not the cause of the problem. If you speed up what the app is doing between the login and logout events, you'll reduce that number.

    -- J.Kozloski, MCDBA, MCITP

  • January 4, 2006 at 10:51 am

    #612683

    Thank you J.

    I've been looking through Microsoft's whitepapers, class info etc. but could not find any reference to what the results meant.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply