MS SQL Server Perfmon Transactions (MSSQL_SERVER_PERFMON_TRANSACTIONS)
The MSSQL_SERVER_PERFMON_TRANSACTIONS application class provides counters to monitor the number of transactions active in an instance of the Database Engine, and the effects of those transactions on resources such as the snapshot isolation row version store in tempdb.
Transactions are logical units of work; a set of operations that must either all succeed or all be erased from a database in order to maintain the logical integrity of the data. All modifications of data in SQL Server databases are made in transactions.
Application class attributes
Item | Description |
|---|---|
Active | Yes |
Created by | Discovery |
Parent class | MSSQL_SERVER_PERFMON_CONTAINER |
Child class | None |
Attributes (parameters)
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*