WUtils.com

Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions, ROOT\CIMV2

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

Description

Statistics related to SQL Server transactions.

Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions has 22 properties (13 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
FreeSpaceintempdbKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LongestTransactionRunningTimeWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
NameCIM_StatisticalInformation8 [string]
NonSnapshotVersionTransactionsWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
SnapshotTransactionsWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TransactionsWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
UpdateconflictratioWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
UpdateSnapshotTransactionsWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
VersionCleanuprateKBPersWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
VersionGenerationrateKBPersWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
VersionStoreSizeKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
VersionStoreunitcountWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
VersionStoreunitcreationWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]
VersionStoreunittruncationWin32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions properties

Local properties (13) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions class

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

Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions 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_PerfFormattedData_MSSQLSERVER_SQLServerTransactions Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerTransactions'✓✗✓✗✓
CookedTrue✓✗✓✗✓
Description'Statistics related to SQL Server transactions.'✓✗✓✓✓
DisplayName'SQLServer:Transactions'✓✗✓✓✓
DisplayName009'SQLServer:Transactions'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerTransactions

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