Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks, ROOT\CIMV2
Class
| Methods | Properties (16)
| Qualifiers (14)
| Instances (13)
| Namespaces (1)
VB Script
| C#
| VB.Net
| Search on:Microsoft
Description Describes statistics for individual lock server lock requests
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks properties Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks has 16 properties (7 Local , 9 Derived )
Detailed description of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks properties Local properties (7) of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks class ▲ AverageWaitTimems propertyCIMTYPE 'uint64' CookingType 'PERF_AVERAGE_BULK' Counter 'AverageWaitTimems' CounterType 1073874176 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)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' AverageWaitTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LockRequestsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LockRequestsPersec' CounterType 272696576 Description 'Number of new locks and lock conversions requested from the lock manager.' DisplayName 'Lock Requests/sec' DisplayName009 'Lock Requests/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LockRequestsPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ LockTimeoutsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LockTimeoutsPersec' CounterType 272696576 Description 'Number of lock requests that timed out. This includes requests for NOWAIT locks.' DisplayName 'Lock Timeouts/sec' DisplayName009 'Lock Timeouts/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LockTimeoutsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LockTimeoutstimeout0Persec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LockTimeoutstimeout0Persec' CounterType 272696576 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' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LockTimeoutstimeout0Persec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LockWaitsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LockWaitsPersec' CounterType 272696576 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' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LockWaitsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LockWaitTimems propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LockWaitTimems' CounterType 272696576 Description 'Total wait time (milliseconds) for locks in the last second.' DisplayName 'Lock Wait Time (ms)' DisplayName009 'Lock Wait Time (ms)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LockWaitTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ NumberofDeadlocksPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'NumberofDeadlocksPersec' CounterType 272696576 Description 'Number of lock requests that resulted in a deadlock.' DisplayName 'Number of Deadlocks/sec' DisplayName009 'Number of Deadlocks/sec' HelpIndex 0 PerfIndex 0 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_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks class
▲ Name propertyCIMTYPE '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. ' key True MaxLen 256 read True Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local AutoCook 1 ✓ ✗ ✓ ✗ ✓ AutoCook_RawClass 'Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks' ✓ ✗ ✓ ✗ ✓ Cooked True ✓ ✗ ✓ ✗ ✓ Description 'Describes statistics for individual lock server lock requests' ✓ ✗ ✓ ✓ ✓ DisplayName 'MSSQL$MICROSOFT##WID:Locks' ✓ ✗ ✓ ✓ ✓ DisplayName009 'MSSQL$MICROSOFT##WID:Locks' ✓ ✗ ✓ ✗ ✓ dynamic True ✓ ✗ ✓ ✗ ✓ GenericPerfCtr True ✓ ✗ ✓ ✗ ✓ HelpIndex 0 ✓ ✗ ✓ ✗ ✓ HiPerf True ✓ ✗ ✓ ✗ ✓ Locale 1033 ✓ ✗ ✓ ✓ ✓ PerfIndex 0 ✓ ✗ ✓ ✗ ✓ provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓ RegistryKey 'MSSQL$MICROSOFT##WID' ✓ ✗ ✓ ✗ ✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks System properties Similar Classes to Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLocks Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by