All MIBs › INFORMANT-SQLSERVER-V2 › ss2TransactionsTable
ss2TransactionsTable
Module: INFORMANT-SQLSERVER-V2
OID (symbolic): INFORMANT-SQLSERVER-V2::ss2TransactionsTable
OID (numeric): 1.3.6.1.4.1.9600.1.13.2.36
Node type: OBJECT-TYPE
Access: not-accessible
Description:
The Transactions object in Microsoft SQL Server 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.
When a database is set to allow snapshot isolation level, SQL Server must maintain a record of the modifications made to each row in a database. Each time a row is modified, a copy of the row as it existed before the modification is recorded in a row version store in tempdb. Many of the counters in the Transaction object can be used to monitor the size and rate of growth of the row version store in tempdb.
The Transactions object counters report all transactions in one instance of the Database Engine.
OID Breakdown
| Numeric OID | Name | Module |
|---|---|---|
| 1 | iso | LANART-AGENT |
| 1.3 | org | BIANCA-BRICK-PPP-MIB |
| 1.3.6 | dod | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1 | internet | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1.4 | private | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1.4.1 | enterprises | ANIROOT-MIB |
| 1.3.6.1.4.1.9600 | wtcs | WTCS |
| 1.3.6.1.4.1.9600.1 | informant | WTCS |
| 1.3.6.1.4.1.9600.1.13 | sqlServerV2 | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2 | sqlServerEngineV2 | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.36 | ss2TransactionsTable | INFORMANT-SQLSERVER-V2 |