Audit Logout

  • Hi,

    We are using sql 2000 and found that "Audit Logout" in the profiler is using a large amount of time.

    So much so it is making web pages timeout.

    Can anyone advise??

    Matt

  • The duration column for audit logout is the total duration of the connection. It's not the time it took for the logout operation. So if you have a connection that's been open 23 hours, the duration column for audit logout will show 23 hours.

    This probably isn't the cause of your timeout issues.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

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

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