Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks, ROOT\CIMV2

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

Description

Describes statistics for individual lock server lock requests

Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks has 16 properties (7 Local, 9 Derived)

NameOriginCIMType
AverageWaitTimemsWin32_PerfFormattedData_MSSQLSERVER_SQLServerLocks21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LockRequestsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerLocks21 [uint64]
LockTimeoutsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerLocks21 [uint64]
LockTimeoutstimeout0PersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerLocks21 [uint64]
LockWaitsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerLocks21 [uint64]
LockWaitTimemsWin32_PerfFormattedData_MSSQLSERVER_SQLServerLocks21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
NumberofDeadlocksPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerLocks21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks properties

Local properties (7) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks class

AverageWaitTimems property
CIMTYPE'uint64'
CookingType'PERF_AVERAGE_BULK'
Counter'AverageWaitTimems'
CounterType1073874176
Description'The average amount of wait time (milliseconds) for each lock request that resulted in a wait.'
DisplayName'Average Wait Time (ms)'
DisplayName009'Average Wait Time (ms)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
AverageWaitTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
LockRequestsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LockRequestsPersec'
CounterType272696576
Description'Number of new locks and lock conversions requested from the lock manager.'
DisplayName'Lock Requests/sec'
DisplayName009'Lock Requests/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LockRequestsPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
LockTimeoutsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LockTimeoutsPersec'
CounterType272696576
Description'Number of lock requests that timed out. This includes requests for NOWAIT locks.'
DisplayName'Lock Timeouts/sec'
DisplayName009'Lock Timeouts/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LockTimeoutsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
LockTimeoutstimeout0Persec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LockTimeoutstimeout0Persec'
CounterType272696576
Description'Number of lock requests that timed out. This does not include requests for NOWAIT locks.'
DisplayName'Lock Timeouts (timeout > 0)/sec'
DisplayName009'Lock Timeouts (timeout > 0)/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LockTimeoutstimeout0Persec property is in 4 classes of ROOT\cimv2 and in 1 namespace
LockWaitsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LockWaitsPersec'
CounterType272696576
Description'Number of lock requests that could not be satisfied immediately and required the caller to wait before being granted the lock.'
DisplayName'Lock Waits/sec'
DisplayName009'Lock Waits/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LockWaitsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
LockWaitTimems property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LockWaitTimems'
CounterType272696576
Description'Total wait time (milliseconds) for locks in the last second.'
DisplayName'Lock Wait Time (ms)'
DisplayName009'Lock Wait Time (ms)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LockWaitTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
NumberofDeadlocksPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'NumberofDeadlocksPersec'
CounterType272696576
Description'Number of lock requests that resulted in a deadlock.'
DisplayName'Number of Deadlocks/sec'
DisplayName009'Number of Deadlocks/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
NumberofDeadlocksPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks 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_SQLServerLocks Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerLocks'
CookedTrue
Description'Describes statistics for individual lock server lock requests'
DisplayName'SQLServer:Locks'
DisplayName009'SQLServer:Locks'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQLSERVER'

Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfFormattedData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT16___SYSTEM3
__RELPATH'Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfFormattedData'___SYSTEM8
__CLASS'Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks

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