SQL Transaction Information service

The SQL Transaction Information service monitors the transaction performance of an SQL server.

Service TypeWMI
Instances on a Device15
Supported Systems/ApplicationsMicrosoft SQL Server
Device ClassServer - Generic, Workstation - Generic, Other, Printer, Scanner/Camera, Switch/Router, Laptop - Windows, Server - Windows, and Workstation - Windows
Monitored ByWindows agent
Scan Interval 15 minutes


Status DetailDescription
Latch Waits Per SecondLatch requests that could not be granted immediately.
Full Scans Per SecondScans performed on base tables or indexes.
User ConnectionsUsers currently connected to the SQL server.
Logins Per SecondLogin attempts started.