WUtils.com

Win32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType, ROOT\CIMV2

Class | Methods | Properties (17) | Qualifiers (14) | Instances (4) | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Description

Counters for cursor properties grouped by type

Win32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType has 17 properties (8 Local, 9 Derived)

NameOriginCIMType
ActivecursorsWin32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType21 [uint64]
CachedCursorCountsWin32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType21 [uint64]
CacheHitRatioWin32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CursorCacheUseCountsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType21 [uint64]
CursormemoryusageWin32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType21 [uint64]
CursorRequestsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType21 [uint64]
CursorworktableusageWin32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
NumberofactivecursorplansWin32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType properties

Local properties (8) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType class

…
▲ Activecursors property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Activecursors'
CounterType65792
Description'Number of active cursors.'
DisplayName'Active cursors'
DisplayName009'Active cursors'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Activecursors property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CachedCursorCounts property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'CachedCursorCounts'
CounterType65792
Description'Number of cursors of a given type in the cache'
DisplayName'Cached Cursor Counts'
DisplayName009'Cached Cursor Counts'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CachedCursorCounts property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CacheHitRatio property
CIMTYPE'uint64'
CookingType''
Counter'CacheHitRatio'
CounterType537003264
Description'Ratio between cache hits and lookups'
DisplayName'Cache Hit Ratio'
DisplayName009'Cache Hit Ratio'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CacheHitRatio property is in 12 classes of ROOT\cimv2 and in 1 namespace
…
▲ CursorCacheUseCountsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'CursorCacheUseCountsPersec'
CounterType272696576
Description'Times each type of cached cursor has been used'
DisplayName'Cursor Cache Use Counts/sec'
DisplayName009'Cursor Cache Use Counts/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CursorCacheUseCountsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Cursormemoryusage property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Cursormemoryusage'
CounterType65792
Description'Amount of memory consumed by cursors (KB).'
DisplayName'Cursor memory usage'
DisplayName009'Cursor memory usage'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Cursormemoryusage property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CursorRequestsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'CursorRequestsPersec'
CounterType272696576
Description'Number of SQL cursor requests received by server.'
DisplayName'Cursor Requests/sec'
DisplayName009'Cursor Requests/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CursorRequestsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Cursorworktableusage property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Cursorworktableusage'
CounterType65792
Description'Number of worktables used by cursors.'
DisplayName'Cursor worktable usage'
DisplayName009'Cursor worktable usage'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Cursorworktableusage property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Numberofactivecursorplans property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Numberofactivecursorplans'
CounterType65792
Description'Number of cursor plans.'
DisplayName'Number of active cursor plans'
DisplayName009'Number of active cursor plans'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Numberofactivecursorplans property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType 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_MSSQLSERVER_SQLServerCursorManagerbyType Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerCursorManagerbyType'✓✗✓✗✓
CookedTrue✓✗✓✗✓
Description'Counters for cursor properties grouped by type'✓✗✓✓✓
DisplayName'SQLServer:Cursor Manager by Type'✓✗✓✓✓
DisplayName009'SQLServer:Cursor Manager by Type'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerCursorManagerbyType

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