Monday 19 October 2015

Worried about Audit Logout

I must have been staring at SQL Server profiler on and off for 10 years looking for durations of greater than 100.

It’s always worried me that are many audit logout events like the one below have such high numbers -

Audit Logout        .Net SqlClient Data Provider        web_user   0    3733    0    656    700    52   

656  – that’s a lifetime.

Seems I was right to ignore them though!

According to MS

Duration - Contains the length of time between the login event and the logout event.

At last I can sleep easy.

No comments:

Post a Comment