Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring, ROOT\CIMV2
Class
| Methods | Properties (30)
| Qualifiers (14)
| Instances | Namespaces (1)
Samples: VB Script
| C#
| VB.Net
| Search on:Microsoft
Description This defines a Database Mirroring object for SQL Server
Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring properties Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring has 30 properties (21 Local , 9 Derived )
Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring properties Local properties (21) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring class ▲ BytesReceivedPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'BytesReceivedPersec' CounterType 272696576 Description 'Number of bytes received per second' DisplayName 'Bytes Received/sec' DisplayName009 'Bytes Received/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' BytesReceivedPersec property is in 40 classes of ROOT\cimv2 and in 1 namespace
▲ BytesSentPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'BytesSentPersec' CounterType 272696576 Description 'Number of bytes sent per second' DisplayName 'Bytes Sent/sec' DisplayName009 'Bytes Sent/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' BytesSentPersec property is in 30 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesReceivedPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LogBytesReceivedPersec' CounterType 272696576 Description 'Number of bytes of log received per second' DisplayName 'Log Bytes Received/sec' DisplayName009 'Log Bytes Received/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogBytesReceivedPersec property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesRedonefromCachePersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LogBytesRedonefromCachePersec' CounterType 272696576 Description 'Number of log bytes which were redone from the Database Mirroring log cache per second.' DisplayName 'Log Bytes Redone from Cache/sec' DisplayName009 'Log Bytes Redone from Cache/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogBytesRedonefromCachePersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesSentfromCachePersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LogBytesSentfromCachePersec' CounterType 272696576 Description 'Number of sent log bytes which were sent from the Database Mirroring log cache in the last second.' DisplayName 'Log Bytes Sent from Cache/sec' DisplayName009 'Log Bytes Sent from Cache/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogBytesSentfromCachePersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesSentPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LogBytesSentPersec' CounterType 272696576 Description 'Number of bytes of log sent per second' DisplayName 'Log Bytes Sent/sec' DisplayName009 'Log Bytes Sent/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogBytesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogCompressedBytesRcvdPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LogCompressedBytesRcvdPersec' CounterType 272696576 Description 'Number of compressed bytes of log received in the last second.' DisplayName 'Log Compressed Bytes Rcvd/sec' DisplayName009 'Log Compressed Bytes Rcvd/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogCompressedBytesRcvdPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogCompressedBytesSentPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LogCompressedBytesSentPersec' CounterType 272696576 Description 'Number of compressed bytes of log sent in the last second.' DisplayName 'Log Compressed Bytes Sent/sec' DisplayName009 'Log Compressed Bytes Sent/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogCompressedBytesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogHardenTimems propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LogHardenTimems' CounterType 272696576 Description 'Milliseconds log blocks waited to be hardened to disk in the last second.' DisplayName 'Log Harden Time (ms)' DisplayName009 'Log Harden Time (ms)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogHardenTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogRemainingforUndoKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'LogRemainingforUndoKB' CounterType 65792 Description 'Total number of kilobytes of log that remain to be scanned by the new mirror server after failover.' DisplayName 'Log Remaining for Undo KB' DisplayName009 'Log Remaining for Undo KB' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogRemainingforUndoKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogScannedforUndoKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'LogScannedforUndoKB' CounterType 65792 Description 'Total number of kilobytes of log that have been scanned by the new mirror server after failover.' DisplayName 'Log Scanned for Undo KB' DisplayName009 'Log Scanned for Undo KB' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogScannedforUndoKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogSendFlowControlTimems propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'LogSendFlowControlTimems' CounterType 272696576 Description 'Milliseconds log stream messages waited for send flow control in the last second.' DisplayName 'Log Send Flow Control Time (ms)' DisplayName009 'Log Send Flow Control Time (ms)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogSendFlowControlTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogSendQueueKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'LogSendQueueKB' CounterType 65792 Description 'Total number of kilobytes of log that have not been sent to the mirror server' DisplayName 'Log Send Queue KB' DisplayName009 'Log Send Queue KB' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogSendQueueKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ MirroredWriteTransactionsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'MirroredWriteTransactionsPersec' CounterType 272696576 Description 'Number of transactions which wrote to the mirrored database in the last second, that waited for log to be sent to the mirror.' DisplayName 'Mirrored Write Transactions/sec' DisplayName009 'Mirrored Write Transactions/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' MirroredWriteTransactionsPersec property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ PagesSentPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'PagesSentPersec' CounterType 272696576 Description 'Number of pages sent per second' DisplayName 'Pages Sent/sec' DisplayName009 'Pages Sent/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' PagesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ ReceivesPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'ReceivesPersec' CounterType 272696576 Description 'Number of mirroring message receives per second' DisplayName 'Receives/sec' DisplayName009 'Receives/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' ReceivesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ RedoBytesPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'RedoBytesPersec' CounterType 272696576 Description 'Number of bytes of log redone by the mirror database per second' DisplayName 'Redo Bytes/sec' DisplayName009 'Redo Bytes/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' RedoBytesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ RedoQueueKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'RedoQueueKB' CounterType 65792 Description 'Total number of kilobytes that redo on the mirror database is behind the hardened log' DisplayName 'Redo Queue KB' DisplayName009 'Redo Queue KB' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' RedoQueueKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ SendPerReceiveAckTime propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'SendPerReceiveAckTime' CounterType 272696576 Description 'Milliseconds messages waited for acknowledgement from the partner per second.' DisplayName 'Send/Receive Ack Time' DisplayName009 'Send/Receive Ack Time' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' SendPerReceiveAckTime property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ SendsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'SendsPersec' CounterType 272696576 Description 'Number of sends initiated per second' DisplayName 'Sends/sec' DisplayName009 'Sends/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' SendsPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionDelay propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'TransactionDelay' CounterType 272696576 Description 'Number of milliseconds transaction termination waited for acknowledgement per second.' DisplayName 'Transaction Delay' DisplayName009 'Transaction Delay' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' TransactionDelay property is in 8 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring 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_MSSQLSERVER_SQLServerDatabaseMirroring Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
AutoCook 1 ✓ ✗ ✓ ✗ ✓
AutoCook_RawClass 'Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring' ✓ ✗ ✓ ✗ ✓
Cooked True ✓ ✗ ✓ ✗ ✓
Description 'This defines a Database Mirroring object for SQL Server' ✓ ✗ ✓ ✓ ✓
DisplayName 'SQLServer:Database Mirroring' ✓ ✗ ✓ ✓ ✓
DisplayName009 'SQLServer:Database Mirroring' ✓ ✗ ✓ ✗ ✓
dynamic True ✓ ✗ ✓ ✗ ✓
GenericPerfCtr True ✓ ✗ ✓ ✗ ✓
HelpIndex 0 ✓ ✗ ✓ ✗ ✓
HiPerf True ✓ ✗ ✓ ✗ ✓
Locale 1033 ✓ ✗ ✓ ✓ ✓
PerfIndex 0 ✓ ✗ ✓ ✗ ✓
provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓
RegistryKey 'MSSQLSERVER' ✓ ✗ ✓ ✗ ✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring System properties Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by