SQL Server Performance Forum – Threads Archive
what are sql audit login and audit logout eventi 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.
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.
http://vyaskn.tripod.com/analyzing_profiler_output.htm &http://support.microsoft.com/kb/224587 fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
You should not consider the duration for login logout events because if your application uses connection pooling you may see this value higher… Troubleshooting Performance Problems in SQL Server 2005