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