SQL Transaction Information service
The SQL Transaction Information service monitors the transaction performance of an SQL server.
| Service Type | WMI |
| Instances on a Device | 15 |
| Supported Systems/Applications | Microsoft SQL Server |
| Device Class | Server - Generic, Workstation - Generic, Other, Printer, Scanner/Camera, Switch/Router, Laptop - Windows, Server - Windows, and Workstation - Windows |
| Monitored By | Windows agent |
| Scan Interval | 15 minutes |
| Status Detail | Description |
|---|---|
| Latch Waits Per Second | Latch requests that could not be granted immediately. |
| Full Scans Per Second | Scans performed on base tables or indexes. |
| User Connections | Users currently connected to the SQL server. |
| Logins Per Second | Login attempts started. |