What constitutes a login event?

• Michael L John

  One Orange Chip

  Points: 27038

  More actions

  March 30, 2015 at 1:24 pm

  #306174

  I set up a trigger to capture logins at the server level. This is part of some metrics I am putting together to properly set up load testing.

  I am not surprised by the number of logins from the application logins, but what does surprise me is the number of logins from the various users that can query the production data.

  As an example, my account has 1200+ logins for today only.

  My first thought was that a process was set up to use my login by mistake. This also applies to some of the other users.

  But, there are no processes that are using any login except for the SQL service account or the applications logins.

  What constitutes a login event?

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/