WUtils.com

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions, ROOT\CIMV2

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

Description

Statistics related to SQL Server transactions.

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions properties

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions has 23 properties (14 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
FreeSpaceintempdbKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LongestTransactionRunningTimeWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
NameCIM_StatisticalInformation8 [string]
NonSnapshotVersionTransactionsWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
SnapshotTransactionsWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TransactionsWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
UpdateconflictratioWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
Updateconflictratio_BaseWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions19 [uint32]
UpdateSnapshotTransactionsWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
VersionCleanuprateKBPersWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
VersionGenerationrateKBPersWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
VersionStoreSizeKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
VersionStoreunitcountWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
VersionStoreunitcreationWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]
VersionStoreunittruncationWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions properties

Local properties (14) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions class

…
▲ FreeSpaceintempdbKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'The free space in tempdb in KB.'
DetailLevel100
DisplayName'Free Space in tempdb (KB)'
DisplayName009'Free Space in tempdb (KB)'
HelpIndex0
PerfIndex0
FreeSpaceintempdbKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LongestTransactionRunningTime property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'The longest running time of any transcation in seconds.'
DetailLevel100
DisplayName'Longest Transaction Running Time'
DisplayName009'Longest Transaction Running Time'
HelpIndex0
PerfIndex0
LongestTransactionRunningTime property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ NonSnapshotVersionTransactions property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'The total number of active non-snapshot transactions that generate version records.'
DetailLevel100
DisplayName'NonSnapshot Version Transactions'
DisplayName009'NonSnapshot Version Transactions'
HelpIndex0
PerfIndex0
NonSnapshotVersionTransactions property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SnapshotTransactions property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'The total number of active snapshot transactions.'
DetailLevel100
DisplayName'Snapshot Transactions'
DisplayName009'Snapshot Transactions'
HelpIndex0
PerfIndex0
SnapshotTransactions property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Transactions property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'The total number of active transactions.'
DetailLevel100
DisplayName'Transactions'
DisplayName009'Transactions'
HelpIndex0
PerfDefaultTrue
PerfIndex0
Transactions property is in 8 classes of ROOT\cimv2 and in 1 namespace
…
▲ Updateconflictratio property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale2
Description'The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions.'
DetailLevel100
DisplayName'Update conflict ratio'
DisplayName009'Update conflict ratio'
HelpIndex0
PerfIndex0
Updateconflictratio property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Updateconflictratio_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
Updateconflictratio_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ UpdateSnapshotTransactions property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'The total number of active snapshot transactions that do updates.'
DetailLevel100
DisplayName'Update Snapshot Transactions'
DisplayName009'Update Snapshot Transactions'
HelpIndex0
PerfIndex0
UpdateSnapshotTransactions property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ VersionCleanuprateKBPers property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-3
Description'The version cleanup rate in KB per seconds.'
DetailLevel100
DisplayName'Version Cleanup rate (KB/s)'
DisplayName009'Version Cleanup rate (KB/s)'
HelpIndex0
PerfIndex0
VersionCleanuprateKBPers property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ VersionGenerationrateKBPers property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-3
Description'The version generation rate in KB per seconds.'
DetailLevel100
DisplayName'Version Generation rate (KB/s)'
DisplayName009'Version Generation rate (KB/s)'
HelpIndex0
PerfIndex0
VersionGenerationrateKBPers property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ VersionStoreSizeKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'The size of the version store in KB.'
DetailLevel100
DisplayName'Version Store Size (KB)'
DisplayName009'Version Store Size (KB)'
HelpIndex0
PerfIndex0
VersionStoreSizeKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ VersionStoreunitcount property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of unit in Version Store.'
DetailLevel100
DisplayName'Version Store unit count'
DisplayName009'Version Store unit count'
HelpIndex0
PerfIndex0
VersionStoreunitcount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ VersionStoreunitcreation property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Creation of new unit in Version Store.'
DetailLevel100
DisplayName'Version Store unit creation'
DisplayName009'Version Store unit creation'
HelpIndex0
PerfIndex0
VersionStoreunitcreation property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ VersionStoreunittruncation property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Truncation of unit in Version Store.'
DetailLevel100
DisplayName'Version Store unit truncation'
DisplayName009'Version Store unit truncation'
HelpIndex0
PerfIndex0
VersionStoreunittruncation property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions 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_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Statistics related to SQL Server transactions.'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'MSSQL$MICROSOFT##WID:Transactions'✓✗✓✓✓
DisplayName009'MSSQL$MICROSOFT##WID:Transactions'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQL$MICROSOFT##WID'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions System properties

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

Similar Classes to Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions

Number of classes:1
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions02201--✓
comments powered by Disqus
WUtils.com