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