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)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
CursordeletesPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursorinsertsPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursorscansstartedPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursoruniqueviolationsPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursorupdatesPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
CursorwriteconflictsPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
DescriptionCIM_StatisticalInformation8 [string]
DustycornerscanretriesPersecuserissuedWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
ExpiredrowsremovedPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
ExpiredrowstouchedPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
RowsreturnedPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
RowstouchedPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
TentativelydeletedrowstouchedPersecWin32_PerfRawData_XTPDatabaseEngine_XTPCursors19 [uint32]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfRawData_XTPDatabaseEngine_XTPCursors properties

Local properties (12) of Win32_PerfRawData_XTPDatabaseEngine_XTPCursors class

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

Derived properties (9) of Win32_PerfRawData_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_PerfRawData_XTPDatabaseEngine_XTPCursors Qualifiers

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

Win32_PerfRawData_XTPDatabaseEngine_XTPCursors System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_XTPDatabaseEngine_XTPCursors'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT21___SYSTEM3
__RELPATH'Win32_PerfRawData_XTPDatabaseEngine_XTPCursors'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8
__CLASS'Win32_PerfRawData_XTPDatabaseEngine_XTPCursors'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to Win32_PerfRawData_XTPDatabaseEngine_XTPCursors

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