Post reply

Profiler Trace

  • February 3, 2004 at 10:15 am

    #85449

    I am using SQL Profiler to try and analyze what parts of my application are causing slowdowns. What I come across every 20-25 executions is a description that reads Audit Logout. This particular execution has a duration of over 300k+. Can somebody tell me what this is. Or is there an article which can bring me up to speed on using Profiler

     

    Thanks

  • February 3, 2004 at 11:12 am

    #492659

    Not sure on this one but it might be a security check on the security settings of the SQL Server itself. In EM, right-click the servername, properties and look at security (specifically auditing)

    HTH

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • February 4, 2004 at 6:12 am

    #492739

    Audit Logout is an event that you selected to pick up in your trace.  The duration for the Audit Logout event is how long that connection was connected to the SQL server.

    I hope this helps.

    Jarret

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

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