WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly, ROOT\CIMV2

Class | Methods | Properties (24) | Qualifiers (14) | Instances (1) | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Description

Statistics associated with the agents of Transaction Coordination Manager

Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly properties

Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly has 24 properties (15 Local, 9 Derived)

NameOriginCIMType
AveragecommitwaittimeWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
Averagecommitwaittime_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly19 [uint32]
AveragetranpreparetimeWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
Averagetranpreparetime_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly19 [uint32]
AvgAGEprocessingtimeWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
AvgAGEprocessingtime_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly19 [uint32]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
NameCIM_StatisticalInformation8 [string]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TransactionbranchesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
TransactionparticipantsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
TransactionrequestsperAGEWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
TransactionrequestsperAGE_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly19 [uint32]
TransactionscommittedperAGEWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
TransactionscommittedperAGE_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly19 [uint32]
TransactionscommittedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
TransactionsrolledbackPersecWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]
TransactionsStartedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly properties

Local properties (15) of Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly class

…
▲ Averagecommitwaittime property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average wait time (in milliseconds) for committing a transaction'
DetailLevel100
DisplayName'Average commit wait time'
DisplayName009'Average commit wait time'
HelpIndex0
PerfIndex0
Averagecommitwaittime property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Averagecommitwaittime_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
Averagecommitwaittime_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ Averagetranpreparetime property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) it takes to prepare a federated transaction for commit'
DetailLevel100
DisplayName'Average tran prepare time'
DisplayName009'Average tran prepare time'
HelpIndex0
PerfIndex0
Averagetranpreparetime property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Averagetranpreparetime_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
Averagetranpreparetime_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgAGEprocessingtime property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time (in milliseconds) taken by a TCM Agent to process an AGE message'
DetailLevel100
DisplayName'Avg. AGE processing time'
DisplayName009'Avg. AGE processing time'
HelpIndex0
PerfIndex0
AvgAGEprocessingtime property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgAGEprocessingtime_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgAGEprocessingtime_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionbranchesPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of federated transaction branches created per second'
DetailLevel100
DisplayName'Transaction branches/sec'
DisplayName009'Transaction branches/sec'
HelpIndex0
PerfIndex0
TransactionbranchesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionparticipantsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'The number of bricks participating in a federated transaction per second'
DetailLevel100
DisplayName'Transaction participants/sec'
DisplayName009'Transaction participants/sec'
HelpIndex0
PerfIndex0
TransactionparticipantsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionrequestsperAGE property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average transaction requests sent to TCM per AGE message'
DetailLevel100
DisplayName'Transaction requests per AGE'
DisplayName009'Transaction requests per AGE'
HelpIndex0
PerfIndex0
TransactionrequestsperAGE property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionrequestsperAGE_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
TransactionrequestsperAGE_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionscommittedperAGE property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average number of transactions committed or aborted per AGE'
DetailLevel100
DisplayName'Transactions committed per AGE'
DisplayName009'Transactions committed per AGE'
HelpIndex0
PerfIndex0
TransactionscommittedperAGE property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionscommittedperAGE_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
TransactionscommittedperAGE_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionscommittedPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of federated transactions committed locally per second'
DetailLevel100
DisplayName'Transactions committed/sec'
DisplayName009'Transactions committed/sec'
HelpIndex0
PerfIndex0
TransactionscommittedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionsrolledbackPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of federated transactions rolled back locally per second'
DetailLevel100
DisplayName'Transactions rolled back/sec'
DisplayName009'Transactions rolled back/sec'
HelpIndex0
PerfIndex0
TransactionsrolledbackPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TransactionsStartedPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of federated transactions started locally per second'
DetailLevel100
DisplayName'Transactions Started/sec'
DisplayName009'Transactions Started/sec'
HelpIndex0
PerfDefaultTrue
PerfIndex0
TransactionsStartedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly class

…
▲ Caption property
CIMTYPE'string'
Description'A short textual description (one-line string) for the statistic or metric.'
MaxLen64
readTrue
Caption property is in 1050 classes of ROOT\cimv2 and in 37 namespaces
…
▲ Description property
CIMTYPE'string'
Description'A textual description of the statistic or metric.'
readTrue
Description property is in 1061 classes of ROOT\cimv2 and in 142 namespaces
…
▲ Frequency_Object property
CIMTYPE'uint64'
Frequency_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Frequency_PerfTime property
CIMTYPE'uint64'
Frequency_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Frequency_Sys100NS property
CIMTYPE'uint64'
Frequency_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Name property
CIMTYPE'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. '
MaxLen256
readTrue
Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
…
▲ Timestamp_Object property
CIMTYPE'uint64'
Timestamp_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Timestamp_PerfTime property
CIMTYPE'uint64'
Timestamp_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Timestamp_Sys100NS property
CIMTYPE'uint64'
Timestamp_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
CostlyTrue✓✗✓✗✓
Description'Statistics associated with the agents of Transaction Coordination Manager'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:TCM Agents'✓✗✓✓✓
DisplayName009'SQLServer:TCM Agents'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly System properties

…
NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly'___SYSTEM8✗✗
__NAMESPACE'ROOT\cimv2'___SYSTEM8✗✗
__SERVER'.'___SYSTEM8✗✗
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8✗✓
__PROPERTY_COUNT24___SYSTEM3✗✗
__RELPATH'Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly'___SYSTEM8✗✗
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8✗✗
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8✗✗
__CLASS'Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly'___SYSTEM8✗✗
__GENUS1___SYSTEM3✗✗

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly

Number of classes:37
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDCloudDBMessaging_Costly01301--✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDCloudDBReplication_Costly01701--✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTCMAgents_Costly01901--✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTraceEventStatistics_Costly0140----
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTraceStatistics_Costly0130----
Win32_PerfFormattedData_MSSQLSERVER_SQLServerCloudDBMessaging_Costly01301--✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerCloudDBReplication_Costly01701--✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerTCMAgents_Costly01901--✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly0140----
Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlSoftPartition_Costly0140----
Win32_PerfFormattedData_MSSQLSERVER_SQLServerTraceEventStatistics_Costly0140----
Win32_PerfFormattedData_MSSQLSERVER_SQLServerTraceStatistics_Costly0130----
Win32_PerfFormattedData_PerfProc_FullImage_Costly017040---
Win32_PerfFormattedData_PerfProc_Heap_Costly03303---
Win32_PerfFormattedData_PerfProc_Image_Costly017040---
Win32_PerfFormattedData_PerfProc_ProcessAddressSpace_Costly046040---
Win32_PerfFormattedData_PerfProc_ThreadDetails_Costly010040---
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDCloudDBMessaging_Costly01301--✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDCloudDBReplication_Costly01701--✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTCMAgents_Costly02401--✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTraceEventStatistics_Costly0140----
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTraceStatistics_Costly0130----
Win32_PerfRawData_MSSQLSERVER_SQLServerCloudDBMessaging_Costly01301--✓
Win32_PerfRawData_MSSQLSERVER_SQLServerCloudDBReplication_Costly01701--✓
Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly0140----
Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlSoftPartition_Costly0140----
Win32_PerfRawData_MSSQLSERVER_SQLServerTraceEventStatistics_Costly0140----
Win32_PerfRawData_MSSQLSERVER_SQLServerTraceStatistics_Costly0130----
Win32_PerfRawData_PerfProc_FullImage_Costly017040---
Win32_PerfRawData_PerfProc_Heap_Costly03303---
Win32_PerfRawData_PerfProc_Image_Costly017040---
Win32_PerfRawData_PerfProc_ProcessAddressSpace_Costly046040---
Win32_PerfRawData_PerfProc_ThreadDetails_Costly010040---
comments powered by Disqus
WUtils.com