SQL Server Performance

what are sql audit login and audit logout event

Discussion in 'SQL Server 2005 General DBA Questions' started by akshyat, Jan 8, 2007.

  1. akshyat New Member

    i am using sql profiler for checkhing performance of my application in that i am getting two event very frequently audit login and audit logout and duretion for that are more than 300000 ms.my question is that due to this prformance falls ? if yes how to stop them.
  2. thomas New Member

    No.. the events are just users logging in and out. The reason they have such high durations is that the duration of each logout is the length of time the user was connected to the server before disconnecting. This means these events do not indicate a performance problem.

    You can filter these out in your Profiler set up.
  3. satya Moderator

  4. MohammedU New Member

Share This Page