The General Statistics object in Microsoft® SQL Server™ provides counters to monitor general server-wide activity such as the number of current connections and the number of users connecting and disconnecting from computers running SQL Server per second. Monitoring the number of logins and logouts per second is useful when you are working on large online transaction processing (OLTP) type systems where there are many clients connecting and disconnecting from computers running SQL Server.
These are the SQL Server General Statistics counters.
SQL Server General Statistics counters | Description |
---|---|
Logins/sec | Total number of logins started per second. |
Logouts/sec | Total number of logout operations started per second. |
User Connections | Number of user connections. Because each user connection consumes some memory, configuring overly high numbers of user connections could affect throughput. User connections should be set to the maximum expected number of concurrent users. |