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