Win32_PerfFormattedData_XTPDatabaseEngine_XTPTransactions, ROOT\CIMV2
Class
| Methods | Properties (19)
| Qualifiers (14)
| Instances | Namespaces (1)
Samples: 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_PerfFormattedData_XTPDatabaseEngine_XTPTransactions properties Win32_PerfFormattedData_XTPDatabaseEngine_XTPTransactions has 19 properties (10 Local , 9 Derived )
Detailed description of Win32_PerfFormattedData_XTPDatabaseEngine_XTPTransactions properties Local properties (10) of Win32_PerfFormattedData_XTPDatabaseEngine_XTPTransactions class ▲ CascadingabortsPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'CascadingabortsPersec' CounterType 272696320 Description 'The number of transactions that rolled back to due a commit dependency rollback (on average), per second.' DisplayName 'Cascading aborts/sec' DisplayName009 'Cascading aborts/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' CascadingabortsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ CommitdependenciestakenPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'CommitdependenciestakenPersec' CounterType 272696320 Description 'The number of commit dependencies taken by transactions (on average), per second.' DisplayName 'Commit dependencies taken/sec' DisplayName009 'Commit dependencies taken/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' CommitdependenciestakenPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ ReadonlytransactionspreparedPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'ReadonlytransactionspreparedPersec' CounterType 272696320 Description 'The number of read-only transactions that were prepared for commit processing, per second.' DisplayName 'Read-only transactions prepared/sec' DisplayName009 'Read-only transactions prepared/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' ReadonlytransactionspreparedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ SavepointrefreshesPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'SavepointrefreshesPersec' CounterType 272696320 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.' DisplayName 'Save point refreshes/sec' DisplayName009 'Save point refreshes/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' SavepointrefreshesPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ SavepointrollbacksPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'SavepointrollbacksPersec' CounterType 272696320 Description 'The number of times a transaction rolled back to a save point (on average), per second.' DisplayName 'Save point rollbacks/sec' DisplayName009 'Save point rollbacks/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' SavepointrollbacksPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ SavepointscreatedPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'SavepointscreatedPersec' CounterType 272696320 Description 'The number of save points created (on average), per second.' DisplayName 'Save points created/sec' DisplayName009 'Save points created/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' SavepointscreatedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionsabortedbyuserPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'TransactionsabortedbyuserPersec' CounterType 272696320 Description 'The number of transactions that were aborted by the user (on average), per second.' DisplayName 'Transactions aborted by user/sec' DisplayName009 'Transactions aborted by user/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' TransactionsabortedbyuserPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionsabortedPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'TransactionsabortedPersec' CounterType 272696320 Description 'The number of transactions that aborted (both by the user and the system, on average), per second.' DisplayName 'Transactions aborted/sec' DisplayName009 'Transactions aborted/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' TransactionsabortedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionscreatedPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'TransactionscreatedPersec' CounterType 272696320 Description 'The number of transactions created in the system (on average), per second.' DisplayName 'Transactions created/sec' DisplayName009 'Transactions created/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' TransactionscreatedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionvalidationfailuresPersec propertyCIMTYPE 'uint32' CookingType 'PERF_COUNTER_COUNTER' Counter 'TransactionvalidationfailuresPersec' CounterType 272696320 Description 'The number of transactions that failed validation processing (on average), per second.' DisplayName 'Transaction validation failures/sec' DisplayName009 'Transaction validation failures/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' TransactionvalidationfailuresPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfFormattedData_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_PerfFormattedData_XTPDatabaseEngine_XTPTransactions Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
AutoCook 1 ✓ ✗ ✓ ✗ ✓
AutoCook_RawClass 'Win32_PerfRawData_XTPDatabaseEngine_XTPTransactions' ✓ ✗ ✓ ✗ ✓
Cooked True ✓ ✗ ✓ ✗ ✓
Description 'The XTP Transactions performance object contains counters related to XTP engine transactions in SQL Server.' ✓ ✗ ✓ ✓ ✓
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_PerfFormattedData_XTPDatabaseEngine_XTPTransactions System properties Similar Classes to Win32_PerfFormattedData_XTPDatabaseEngine_XTPTransactions Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by