WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerLocks, ROOT\CIMV2

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

Description

Describes statistics for individual lock server lock requests

Win32_PerfRawData_MSSQLSERVER_SQLServerLocks properties

Win32_PerfRawData_MSSQLSERVER_SQLServerLocks has 17 properties (8 Local, 9 Derived)

NameOriginCIMType
AverageWaitTimemsWin32_PerfRawData_MSSQLSERVER_SQLServerLocks21 [uint64]
AverageWaitTimems_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerLocks19 [uint32]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LockRequestsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerLocks21 [uint64]
LockTimeoutsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerLocks21 [uint64]
LockTimeoutstimeout0PersecWin32_PerfRawData_MSSQLSERVER_SQLServerLocks21 [uint64]
LockWaitsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerLocks21 [uint64]
LockWaitTimemsWin32_PerfRawData_MSSQLSERVER_SQLServerLocks21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
NumberofDeadlocksPersecWin32_PerfRawData_MSSQLSERVER_SQLServerLocks21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerLocks properties

Local properties (8) of Win32_PerfRawData_MSSQLSERVER_SQLServerLocks class

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

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

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Describes statistics for individual lock server lock requests'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:Locks'✓✗✓✓✓
DisplayName009'SQLServer:Locks'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerLocks System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerLocks

Number of classes:1
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerLocks016014---
WUtils.com
online utility - toplist