WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerLocks, ROOT\cimv2 - Instances

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

Instances of Win32_PerfRawData_MSSQLSERVER_SQLServerLocks

This section contains sample wmi instances of Win32_PerfRawData_MSSQLSERVER_SQLServerLocks class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation.
…

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="RowGroup"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '0' //String, 0x0
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'RowGroup' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="OIB"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '0' //String, 0x0
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'OIB' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="AllocUnit"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '0' //String, 0x0
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'AllocUnit' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="HoBT"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '2310' //String, 0x906
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'HoBT' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="Metadata"

Properties={
   'AverageWaitTimems' : '125' //String, 0x7D
   'AverageWaitTimems_Base' : 1 //Long, 0x1
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '398464' //String, 0x61480
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '1' //String, 0x1
   'LockWaitTimems' : '125' //String, 0x7D
   'Name' : 'Metadata' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="Application"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '0' //String, 0x0
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'Application' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="RID"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '755' //String, 0x2F3
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'RID' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="Extent"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '7035' //String, 0x1B7B
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'Extent' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="Key"

Properties={
   'AverageWaitTimems' : '765' //String, 0x2FD
   'AverageWaitTimems_Base' : 7 //Long, 0x7
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '1365994' //String, 0x14D7EA
   'LockTimeoutsPersec' : '107' //String, 0x6B
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '7' //String, 0x7
   'LockWaitTimems' : '765' //String, 0x2FD
   'Name' : 'Key' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="Page"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '2440' //String, 0x988
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'Page' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="Object"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '1171474' //String, 0x11E012
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'Object' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="File"

Properties={
   'AverageWaitTimems' : '0' //String, 0x0
   'AverageWaitTimems_Base' : 0 //Long, 0x0
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '1641' //String, 0x669
   'LockTimeoutsPersec' : '0' //String, 0x0
   'LockTimeoutstimeout0Persec' : '0' //String, 0x0
   'LockWaitsPersec' : '0' //String, 0x0
   'LockWaitTimems' : '0' //String, 0x0
   'Name' : 'File' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="Database"

Properties={
   'AverageWaitTimems' : '55236' //String, 0xD7C4
   'AverageWaitTimems_Base' : 92 //Long, 0x5C
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '5938123' //String, 0x5A9BCB
   'LockTimeoutsPersec' : '26381' //String, 0x670D
   'LockTimeoutstimeout0Persec' : '5' //String, 0x5
   'LockWaitsPersec' : '92' //String, 0x5C
   'LockWaitTimems' : '55236' //String, 0xD7C4
   'Name' : 'Database' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerLocks.Name="_Total"

Properties={
   'AverageWaitTimems' : '56126' //String, 0xDB3E
   'AverageWaitTimems_Base' : 100 //Long, 0x64
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'LockRequestsPersec' : '8888236' //String, 0x879FAC
   'LockTimeoutsPersec' : '26488' //String, 0x6778
   'LockTimeoutstimeout0Persec' : '5' //String, 0x5
   'LockWaitsPersec' : '100' //String, 0x64
   'LockWaitTimems' : '56126' //String, 0xDB3E
   'Name' : '_Total' //String
   'NumberofDeadlocksPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243071331716' //String
   'Timestamp_Sys100NS' : '130603634117400000' //String
}
comments powered by Disqus
WUtils.com