Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

User - Logins Per Second Alarm

The User - Logins Per Second alarm is raised 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 the alarm is raised

Use Microsoft SQL Server Profiler to monitor connect and disconnect events, and determine if a badly behaving application is causing the problem.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating