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