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 )
Detailed description of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions properties Local properties (14) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions class ▲ FreeSpaceintempdbKB propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'The free space in tempdb in KB.' DetailLevel 100 DisplayName 'Free Space in tempdb (KB)' DisplayName009 'Free Space in tempdb (KB)' HelpIndex 0 PerfIndex 0 FreeSpaceintempdbKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LongestTransactionRunningTime propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'The longest running time of any transcation in seconds.' DetailLevel 100 DisplayName 'Longest Transaction Running Time' DisplayName009 'Longest Transaction Running Time' HelpIndex 0 PerfIndex 0 LongestTransactionRunningTime property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ NonSnapshotVersionTransactions propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'The total number of active non-snapshot transactions that generate version records.' DetailLevel 100 DisplayName 'NonSnapshot Version Transactions' DisplayName009 'NonSnapshot Version Transactions' HelpIndex 0 PerfIndex 0 NonSnapshotVersionTransactions property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ SnapshotTransactions propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'The total number of active snapshot transactions.' DetailLevel 100 DisplayName 'Snapshot Transactions' DisplayName009 'Snapshot Transactions' HelpIndex 0 PerfIndex 0 SnapshotTransactions property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Transactions propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'The total number of active transactions.' DetailLevel 100 DisplayName 'Transactions' DisplayName009 'Transactions' HelpIndex 0 PerfDefault True PerfIndex 0 Transactions property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ Updateconflictratio propertyCIMTYPE 'uint64' CounterType 1073874176 DefaultScale 2 Description 'The fraction of update snapshot transactions that have update conflicts to the total number of update snapshot transactions.' DetailLevel 100 DisplayName 'Update conflict ratio' DisplayName009 'Update conflict ratio' HelpIndex 0 PerfIndex 0 Updateconflictratio property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Updateconflictratio_Base propertyCIMTYPE 'uint32' CounterType 1073939458 DefaultScale 0 Description '' DetailLevel 100 DisplayName '' DisplayName009 '' HelpIndex 0 PerfIndex 0 Updateconflictratio_Base property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ UpdateSnapshotTransactions propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'The total number of active snapshot transactions that do updates.' DetailLevel 100 DisplayName 'Update Snapshot Transactions' DisplayName009 'Update Snapshot Transactions' HelpIndex 0 PerfIndex 0 UpdateSnapshotTransactions property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ VersionCleanuprateKBPers propertyCIMTYPE 'uint64' CounterType 272696576 DefaultScale -3 Description 'The version cleanup rate in KB per seconds.' DetailLevel 100 DisplayName 'Version Cleanup rate (KB/s)' DisplayName009 'Version Cleanup rate (KB/s)' HelpIndex 0 PerfIndex 0 VersionCleanuprateKBPers property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ VersionGenerationrateKBPers propertyCIMTYPE 'uint64' CounterType 272696576 DefaultScale -3 Description 'The version generation rate in KB per seconds.' DetailLevel 100 DisplayName 'Version Generation rate (KB/s)' DisplayName009 'Version Generation rate (KB/s)' HelpIndex 0 PerfIndex 0 VersionGenerationrateKBPers property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ VersionStoreSizeKB propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'The size of the version store in KB.' DetailLevel 100 DisplayName 'Version Store Size (KB)' DisplayName009 'Version Store Size (KB)' HelpIndex 0 PerfIndex 0 VersionStoreSizeKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ VersionStoreunitcount propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'Number of unit in Version Store.' DetailLevel 100 DisplayName 'Version Store unit count' DisplayName009 'Version Store unit count' HelpIndex 0 PerfIndex 0 VersionStoreunitcount property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ VersionStoreunitcreation propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'Creation of new unit in Version Store.' DetailLevel 100 DisplayName 'Version Store unit creation' DisplayName009 'Version Store unit creation' HelpIndex 0 PerfIndex 0 VersionStoreunitcreation property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ VersionStoreunittruncation propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'Truncation of unit in Version Store.' DetailLevel 100 DisplayName 'Version Store unit truncation' DisplayName009 'Version Store unit truncation' HelpIndex 0 PerfIndex 0 VersionStoreunittruncation property is in 4 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions 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. ' MaxLen 256 read True Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
Description 'Statistics related to SQL Server transactions.' ✓ ✗ ✓ ✓ ✓
DetailLevel 100 ✓ ✗ ✓ ✗ ✓
DisplayName 'MSSQL$MICROSOFT##WID:Transactions' ✓ ✗ ✓ ✓ ✓
DisplayName009 'MSSQL$MICROSOFT##WID:Transactions' ✓ ✗ ✓ ✗ ✓
dynamic True ✓ ✗ ✓ ✗ ✓
GenericPerfCtr True ✓ ✗ ✓ ✗ ✓
HelpIndex 0 ✓ ✗ ✓ ✗ ✓
HiPerf True ✓ ✗ ✓ ✗ ✓
Locale 1033 ✓ ✗ ✓ ✓ ✓
PerfIndex 0 ✓ ✗ ✓ ✗ ✓
provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓
RegistryKey 'MSSQL$MICROSOFT##WID' ✓ ✗ ✓ ✗ ✓
Singleton True ✓ ✓ ✗ ✗ ✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions System properties Similar Classes to Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTransactions Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by