Question relate to sql profiller

  • I read a profiler and found that there are alot of records that consume large time with evenclass Audit Login , Audit LogOut

    what do they mean?

    do these records affect the performance ?

    if yes ? how to enhance that

  • The audit login event occurs when someone logs in to SQL. The audit logout event occurs when someone logs out of SQL.

    What do you mean by 'affects performance'?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (7/22/2009)


    The audit login event occurs when someone logs in to SQL. The audit logout event occurs when someone logs out of SQL.

    What do you mean by 'affects performance'?

    I mean it take a lot of time , so is it effect the execution time

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

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