Win32_PerfRawData_XTPDatabaseEngine_XTPCursors, ROOT\CIMV2
Class
| Methods | Properties (21)
| Qualifiers (12)
| Instances | Namespaces (1)
Samples: VB Script
| C#
| VB.Net
| Search on:Microsoft
Description The XTP Cursors performance object contains counters related to internal XTP engine cursors. Cursors are the low-level building blocks the XTP engine uses to process T-SQL queries. As such, a user does not typically have direct control over them.
Win32_PerfRawData_XTPDatabaseEngine_XTPCursors properties Win32_PerfRawData_XTPDatabaseEngine_XTPCursors has 21 properties (12 Local , 9 Derived )
Detailed description of Win32_PerfRawData_XTPDatabaseEngine_XTPCursors properties Local properties (12) of Win32_PerfRawData_XTPDatabaseEngine_XTPCursors class ▲ CursordeletesPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of cursor deletes (on average), per second.' DetailLevel 100 DisplayName 'Cursor deletes/sec' DisplayName009 'Cursor deletes/sec' HelpIndex 0 PerfIndex 0 CursordeletesPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ CursorinsertsPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of cursor inserts (on average), per second.' DetailLevel 100 DisplayName 'Cursor inserts/sec' DisplayName009 'Cursor inserts/sec' HelpIndex 0 PerfIndex 0 CursorinsertsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ CursorscansstartedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of cursor scans started (on average), per second.' DetailLevel 100 DisplayName 'Cursor scans started/sec' DisplayName009 'Cursor scans started/sec' HelpIndex 0 PerfDefault True PerfIndex 0 CursorscansstartedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ CursoruniqueviolationsPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of unique-constraint violations (on average), per second.' DetailLevel 100 DisplayName 'Cursor unique violations/sec' DisplayName009 'Cursor unique violations/sec' HelpIndex 0 PerfIndex 0 CursoruniqueviolationsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ CursorupdatesPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of cursor updates (on average), per second.' DetailLevel 100 DisplayName 'Cursor updates/sec' DisplayName009 'Cursor updates/sec' HelpIndex 0 PerfIndex 0 CursorupdatesPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ CursorwriteconflictsPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of write-write conflicts to the same row version (on average), per second.' DetailLevel 100 DisplayName 'Cursor write conflicts/sec' DisplayName009 'Cursor write conflicts/sec' HelpIndex 0 PerfIndex 0 CursorwriteconflictsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ DustycornerscanretriesPersecuserissued propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of scan retries due to write conflicts during dusty corner sweeps issued by a user's full-table scan (on average), per second. This is a very low-level counter, not intended for customer use.' DetailLevel 100 DisplayName 'Dusty corner scan retries/sec (user-issued)' DisplayName009 'Dusty corner scan retries/sec (user-issued)' HelpIndex 0 PerfIndex 0 DustycornerscanretriesPersecuserissued property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ ExpiredrowsremovedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of expired rows removed by cursors (on average), per second.' DetailLevel 100 DisplayName 'Expired rows removed/sec' DisplayName009 'Expired rows removed/sec' HelpIndex 0 PerfIndex 0 ExpiredrowsremovedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ ExpiredrowstouchedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of expired rows touched by cursors (on average), per second.' DetailLevel 100 DisplayName 'Expired rows touched/sec' DisplayName009 'Expired rows touched/sec' HelpIndex 0 PerfIndex 0 ExpiredrowstouchedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ RowsreturnedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of rows returned by cursors (on average), per second.' DetailLevel 100 DisplayName 'Rows returned/sec' DisplayName009 'Rows returned/sec' HelpIndex 0 PerfIndex 0 RowsreturnedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ RowstouchedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of rows touched by cursors (on average), per second.' DetailLevel 100 DisplayName 'Rows touched/sec' DisplayName009 'Rows touched/sec' HelpIndex 0 PerfIndex 0 RowstouchedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ TentativelydeletedrowstouchedPersec propertyCIMTYPE 'uint32' CounterType 272696320 DefaultScale -1 Description 'The number of expiring rows touched by cursors (on average), per second. A row is expiring if the transaction that deleted it is still active (i.e. has not yet committed or aborted.)' DetailLevel 100 DisplayName 'Tentatively-deleted rows touched/sec' DisplayName009 'Tentatively-deleted rows touched/sec' HelpIndex 0 PerfIndex 0 TentativelydeletedrowstouchedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfRawData_XTPDatabaseEngine_XTPCursors 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. ' key True MaxLen 256 read True Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
Win32_PerfRawData_XTPDatabaseEngine_XTPCursors Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
Description 'The XTP Cursors performance object contains counters related to internal XTP engine cursors. Cursors are the low-level building blocks the XTP engine uses to process T-SQL queries. As such, a user does not typically have direct control over them.' ✓ ✗ ✓ ✓ ✓
DetailLevel 100 ✓ ✗ ✓ ✗ ✓
DisplayName 'XTP Cursors' ✓ ✗ ✓ ✓ ✓
DisplayName009 'XTP Cursors' ✓ ✗ ✓ ✗ ✓
dynamic True ✓ ✗ ✓ ✗ ✓
GenericPerfCtr True ✓ ✗ ✓ ✗ ✓
HelpIndex 0 ✓ ✗ ✓ ✗ ✓
HiPerf True ✓ ✗ ✓ ✗ ✓
Locale 1033 ✓ ✗ ✓ ✓ ✓
PerfIndex 0 ✓ ✗ ✓ ✗ ✓
provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓
RegistryKey '{a22f85a5-c5e9-4083-98e3-fd418d83e706}' ✓ ✗ ✓ ✗ ✓
Win32_PerfRawData_XTPDatabaseEngine_XTPCursors System properties Similar Classes to Win32_PerfRawData_XTPDatabaseEngine_XTPCursors Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by