Reduce Audit Logout Time.

Question

Reduce Audit Logout Time.

vijay sagar-355227

SSC Enthusiast

Points: 113
More actions
August 3, 2006 at 8:18 am

#113125

Hi,
Can anyone explain how we can reduce Audit Logout time. I checked in SQL Profiler Audit Logout is taking nearly 1.2 Million Seconds.

Thanks in advance
Vijay Sagar K

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

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

Jo Pattyn SSC-Dedicated Points: 32348 More actions · Answer 1

wow 1.2 Million Seconds

Are all transactions properly committed before logging out? All locks are freed? All cursors are properly closed & deallocated?

Is this with each connection?

WesleyB Ten Centuries Points: 1307 More actions · Answer 2

The time you see there is the sum of the duration that particular SPID was connected. It has nothing to do with the time it takes to close the connection.

Don't worry

Jeff Gray SSChampion Points: 10667 More actions · Answer 3

You could always log out before doing anything. That should reduce it to zero.

Smile. It's Friday!