Administering SQL Server
SQL Server: General Statistics Object
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 per second from computers running an instance of SQL Server. This can be useful when you are working on large online transaction processing (OLTP) type systems where there are many clients connecting and disconnecting from an instance of 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. Set user connections to the maximum expected number of concurrent users. |