Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions, ROOT\CIMV2
Class
| Methods | Properties (19)
| Qualifiers (12)
| Instances | Namespaces (1)
VB Script
| C#
| VB.Net
| Search on:Microsoft
Description The XTP Transactions performance object contains counters related to XTP engine transactions in SQL Server.
Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions properties Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions has 19 properties (10 Local , 9 Derived )
Detailed description of Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions properties Local properties (10) of Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions class ▲ CascadingabortsPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of transactions that rolled back to due a commit dependency rollback (on average), per second.' DetailLevel 100 DisplayName 'Cascading aborts/sec' DisplayName009 'Cascading aborts/sec' HelpIndex 0 PerfIndex 0 CascadingabortsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ CommitdependenciestakenPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of commit dependencies taken by transactions (on average), per second.' DetailLevel 100 DisplayName 'Commit dependencies taken/sec' DisplayName009 'Commit dependencies taken/sec' HelpIndex 0 PerfIndex 0 CommitdependenciestakenPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ ReadonlytransactionspreparedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of read-only transactions that were prepared for commit processing, per second.' DetailLevel 100 DisplayName 'Read-only transactions prepared/sec' DisplayName009 'Read-only transactions prepared/sec' HelpIndex 0 PerfIndex 0 ReadonlytransactionspreparedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ SavepointrefreshesPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of times a savepoint was "refreshed", (on average), per second. A savepoint refresh is when an existing savepoint is reset to the current point in the transaction's lifetime.' DetailLevel 100 DisplayName 'Save point refreshes/sec' DisplayName009 'Save point refreshes/sec' HelpIndex 0 PerfIndex 0 SavepointrefreshesPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ SavepointrollbacksPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of times a transaction rolled back to a save point (on average), per second.' DetailLevel 100 DisplayName 'Save point rollbacks/sec' DisplayName009 'Save point rollbacks/sec' HelpIndex 0 PerfIndex 0 SavepointrollbacksPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ SavepointscreatedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of save points created (on average), per second.' DetailLevel 100 DisplayName 'Save points created/sec' DisplayName009 'Save points created/sec' HelpIndex 0 PerfIndex 0 SavepointscreatedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionsabortedbyuserPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of transactions that were aborted by the user (on average), per second.' DetailLevel 100 DisplayName 'Transactions aborted by user/sec' DisplayName009 'Transactions aborted by user/sec' HelpIndex 0 PerfIndex 0 TransactionsabortedbyuserPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionsabortedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of transactions that aborted (both by the user and the system, on average), per second.' DetailLevel 100 DisplayName 'Transactions aborted/sec' DisplayName009 'Transactions aborted/sec' HelpIndex 0 PerfIndex 0 TransactionsabortedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionscreatedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of transactions created in the system (on average), per second.' DetailLevel 100 DisplayName 'Transactions created/sec' DisplayName009 'Transactions created/sec' HelpIndex 0 PerfDefault True PerfIndex 0 TransactionscreatedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionvalidationfailuresPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of transactions that failed validation processing (on average), per second.' DetailLevel 100 DisplayName 'Transaction validation failures/sec' DisplayName009 'Transaction validation failures/sec' HelpIndex 0 PerfIndex 0 TransactionvalidationfailuresPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions class
▲ Name propertyCIMTYPE 'string' Description 'The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. ' key True MaxLen 256 read True Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local Description 'The XTP Transactions performance object contains counters related to XTP engine transactions in SQL Server.' ✓ ✗ ✓ ✓ ✓ DetailLevel 100 ✓ ✗ ✓ ✗ ✓ DisplayName 'XTP Transactions' ✓ ✗ ✓ ✓ ✓ DisplayName009 'XTP Transactions' ✓ ✗ ✓ ✗ ✓ dynamic True ✓ ✗ ✓ ✗ ✓ GenericPerfCtr True ✓ ✗ ✓ ✗ ✓ HelpIndex 0 ✓ ✗ ✓ ✗ ✓ HiPerf True ✓ ✗ ✓ ✗ ✓ Locale 1033 ✓ ✗ ✓ ✓ ✓ PerfIndex 0 ✓ ✗ ✓ ✗ ✓ provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓ RegistryKey '{a22f85a5-c5e9-4083-98e3-fd418d83e706}' ✓ ✗ ✓ ✗ ✓
Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions System properties Similar Classes to Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by