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.