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

Attributes (parameters)

• Free Space in tempdb (KB) (FreeSpaceInTempdbKB)
• Longest Transaction Running Time (LongestTransactionRunningTime)
• NonSnapshot Version Transactions (NonSnapshotVersionTransactions)
• Snapshot Transactions (SnapshotTransactions)
• Transactions (Transactions)
• Update conflict ratio (UpdateConflictRatio)
• Update Snapshot Transactions (UpdateSnapshotTransactions)
• Version Cleanup rate (KB/s) (VersionCleanupRateKBS)
• Version Generation rate (KB/s) (VersionGenerationRateKBS)
• Version Store Size (KB) (VersionStoreSizeKB)
• Version Store unit count (VersionStoreUnitCount)
• Version Store unit creation (VersionStoreUnitCreation)
• Version Store unit truncation (VersionStoreUnitTruncation)