Profiler What means Audit login audit / Audit logout

[Zargo]

Hi all,

When i'm running the profiler to check whats going wrong with the database i'm seeing a lot of Audit login audit / Audit logout's, and whe chekking the durations it it very very high(a couple of seconds). Sometimes i'm seeing that one of our interfaces will give a output like:
audit login
QUERY
audit logout
audit login
Query
audit logout
audit login
Query
audit logout
and so on.


Is this a mistake in the coding in Visual Basic 6?. What does the Audit login and logouts mean? And why is the duration so long, and could this be a problem for the SQL server environment? We are getting a lot of SPID blocks...

TIA,

 

[vongrunt]

These events happen when clients connect or disconnect. Harmless by default.

Blocked SPIDs are another story - but they aren't directly related to audit events.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)