The User - Logins Per Second alarm becomes active when the average number of logins per second exceeds a threshold. This value is taken over a specific number of background collections.
This can be an indicator of poor application design. Creating a connection to SQL Server is relatively expensive, and coding practices where an application repeatedly connects and disconnects from SQL Server should be avoided.
While reconnecting will not necessarily slow down all users of the SQL Server instance, it will often result in poor performance for the application that is re-connecting all the time.
When this alarm occurs you should:
