Audit Logout

• Senthil T

  Hall of Fame

  Points: 3367

  More actions

  February 13, 2007 at 2:04 pm

  #153430

  Hi,

  I was getting timeout errors from our web application. I launched the SQL Profiler to see what is going on. This line caught my eye.

  Event Class = Audit Logout

  TextData = [empty]

  ApplicationName = .Net SqlClient Data Provider

  NTUserName = NETWORK SERVICE

  LoginName = webuser

  CPU = 766

  Reads = 61689

  Writes = 9

  Duration = 354290

  MSDN says 'The Audit Logout event class indicates that a user has logged out of (logged off) Microsoft SQL Server.'

  So it took 354 seconds for the user 'webuser' to log out of the SQL Server? That doesn't sound right, does it?

  Thanks.

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  February 13, 2007 at 2:18 pm

  #689579

  "So it took 354 seconds for the user 'webuser' to log out of the SQL Server? That doesn't sound right, does it?"

  No, the duration column indicates that time length of the connection.

  The CPU, Reads and Writes are also totals for the connection, not for the logout event.

  SQL = Scarcely Qualifies as a Language