WUtils.com

Win32_PerfFormattedData_XTPDatabaseEngine_XTPCursors, ROOT\CIMV2

Class | Methods | Properties (21) | Qualifiers (14) | 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_PerfFormattedData_XTPDatabaseEngine_XTPCursors properties

Win32_PerfFormattedData_XTPDatabaseEngine_XTPCursors has 21 properties (12 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
CursordeletesPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursorinsertsPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursorscansstartedPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursoruniqueviolationsPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursorupdatesPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursorwriteconflictsPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
DescriptionCIM_StatisticalInformation8 [string]
DustycornerscanretriesPersecuserissuedWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
ExpiredrowsremovedPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
ExpiredrowstouchedPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
RowsreturnedPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
RowstouchedPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
TentativelydeletedrowstouchedPersecWin32_PerfFormattedData_XTPDatabaseEngine_XTPCursors19 [uint32]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfFormattedData_XTPDatabaseEngine_XTPCursors properties

Local properties (12) of Win32_PerfFormattedData_XTPDatabaseEngine_XTPCursors class

…
▲ CursordeletesPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'CursordeletesPersec'
CounterType272696320
Description'The number of cursor deletes (on average), per second.'
DisplayName'Cursor deletes/sec'
DisplayName009'Cursor deletes/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CursordeletesPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ CursorinsertsPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'CursorinsertsPersec'
CounterType272696320
Description'The number of cursor inserts (on average), per second.'
DisplayName'Cursor inserts/sec'
DisplayName009'Cursor inserts/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CursorinsertsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ CursorscansstartedPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'CursorscansstartedPersec'
CounterType272696320
Description'The number of cursor scans started (on average), per second.'
DisplayName'Cursor scans started/sec'
DisplayName009'Cursor scans started/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CursorscansstartedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ CursoruniqueviolationsPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'CursoruniqueviolationsPersec'
CounterType272696320
Description'The number of unique-constraint violations (on average), per second.'
DisplayName'Cursor unique violations/sec'
DisplayName009'Cursor unique violations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CursoruniqueviolationsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ CursorupdatesPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'CursorupdatesPersec'
CounterType272696320
Description'The number of cursor updates (on average), per second.'
DisplayName'Cursor updates/sec'
DisplayName009'Cursor updates/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CursorupdatesPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ CursorwriteconflictsPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'CursorwriteconflictsPersec'
CounterType272696320
Description'The number of write-write conflicts to the same row version (on average), per second.'
DisplayName'Cursor write conflicts/sec'
DisplayName009'Cursor write conflicts/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CursorwriteconflictsPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ DustycornerscanretriesPersecuserissued property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'DustycornerscanretriesPersecuserissued'
CounterType272696320
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.'
DisplayName'Dusty corner scan retries/sec (user-issued)'
DisplayName009'Dusty corner scan retries/sec (user-issued)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DustycornerscanretriesPersecuserissued property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ ExpiredrowsremovedPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'ExpiredrowsremovedPersec'
CounterType272696320
Description'The number of expired rows removed by cursors (on average), per second.'
DisplayName'Expired rows removed/sec'
DisplayName009'Expired rows removed/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ExpiredrowsremovedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ ExpiredrowstouchedPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'ExpiredrowstouchedPersec'
CounterType272696320
Description'The number of expired rows touched by cursors (on average), per second.'
DisplayName'Expired rows touched/sec'
DisplayName009'Expired rows touched/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ExpiredrowstouchedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ RowsreturnedPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'RowsreturnedPersec'
CounterType272696320
Description'The number of rows returned by cursors (on average), per second.'
DisplayName'Rows returned/sec'
DisplayName009'Rows returned/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RowsreturnedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ RowstouchedPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'RowstouchedPersec'
CounterType272696320
Description'The number of rows touched by cursors (on average), per second.'
DisplayName'Rows touched/sec'
DisplayName009'Rows touched/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RowstouchedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ TentativelydeletedrowstouchedPersec property
CIMTYPE'uint32'
CookingType'PERF_COUNTER_COUNTER'
Counter'TentativelydeletedrowstouchedPersec'
CounterType272696320
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.)'
DisplayName'Tentatively-deleted rows touched/sec'
DisplayName009'Tentatively-deleted rows touched/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
TentativelydeletedrowstouchedPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_XTPDatabaseEngine_XTPCursors 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. '
keyTrue
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_XTPDatabaseEngine_XTPCursors Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_XTPDatabaseEngine_XTPCursors'✓✗✓✗✓
CookedTrue✓✗✓✗✓
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.'✓✗✓✓✓
DisplayName'XTP Cursors'✓✗✓✓✓
DisplayName009'XTP Cursors'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'{a22f85a5-c5e9-4083-98e3-fd418d83e706}'✓✗✓✗✓

Win32_PerfFormattedData_XTPDatabaseEngine_XTPCursors System properties

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

Similar Classes to Win32_PerfFormattedData_XTPDatabaseEngine_XTPCursors

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