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)

NameOriginCIMType
BytesReceivedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
BytesSentPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LogBytesReceivedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogBytesRedonefromCachePersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogBytesSentfromCachePersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogBytesSentPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogCompressedBytesRcvdPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogCompressedBytesSentPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogHardenTimemsWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogRemainingforUndoKBWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogScannedforUndoKBWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogSendFlowControlTimemsWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogSendQueueKBWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
MirroredWriteTransactionsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
PagesSentPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
ReceivesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
RedoBytesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
RedoQueueKBWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
SendPerReceiveAckTimeWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
SendsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TransactionDelayWin32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring properties

Local properties (21) of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring class

▲ BytesReceivedPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of bytes received per second'
DetailLevel100
DisplayName'Bytes Received/sec'
DisplayName009'Bytes Received/sec'
HelpIndex0
PerfIndex0
BytesReceivedPersec property is in 40 classes of ROOT\cimv2 and in 1 namespace
▲ BytesSentPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of bytes sent per second'
DetailLevel100
DisplayName'Bytes Sent/sec'
DisplayName009'Bytes Sent/sec'
HelpIndex0
PerfDefaultTrue
PerfIndex0
BytesSentPersec property is in 30 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesReceivedPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of bytes of log received per second'
DetailLevel100
DisplayName'Log Bytes Received/sec'
DisplayName009'Log Bytes Received/sec'
HelpIndex0
PerfIndex0
LogBytesReceivedPersec property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesRedonefromCachePersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of log bytes which were redone from the Database Mirroring log cache per second.'
DetailLevel100
DisplayName'Log Bytes Redone from Cache/sec'
DisplayName009'Log Bytes Redone from Cache/sec'
HelpIndex0
PerfIndex0
LogBytesRedonefromCachePersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesSentfromCachePersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of sent log bytes which were sent from the Database Mirroring log cache in the last second.'
DetailLevel100
DisplayName'Log Bytes Sent from Cache/sec'
DisplayName009'Log Bytes Sent from Cache/sec'
HelpIndex0
PerfIndex0
LogBytesSentfromCachePersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesSentPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of bytes of log sent per second'
DetailLevel100
DisplayName'Log Bytes Sent/sec'
DisplayName009'Log Bytes Sent/sec'
HelpIndex0
PerfIndex0
LogBytesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogCompressedBytesRcvdPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of compressed bytes of log received in the last second.'
DetailLevel100
DisplayName'Log Compressed Bytes Rcvd/sec'
DisplayName009'Log Compressed Bytes Rcvd/sec'
HelpIndex0
PerfIndex0
LogCompressedBytesRcvdPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogCompressedBytesSentPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of compressed bytes of log sent in the last second.'
DetailLevel100
DisplayName'Log Compressed Bytes Sent/sec'
DisplayName009'Log Compressed Bytes Sent/sec'
HelpIndex0
PerfIndex0
LogCompressedBytesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogHardenTimems property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Milliseconds log blocks waited to be hardened to disk in the last second.'
DetailLevel100
DisplayName'Log Harden Time (ms)'
DisplayName009'Log Harden Time (ms)'
HelpIndex0
PerfIndex0
LogHardenTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogRemainingforUndoKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Total number of kilobytes of log that remain to be scanned by the new mirror server after failover.'
DetailLevel100
DisplayName'Log Remaining for Undo KB'
DisplayName009'Log Remaining for Undo KB'
HelpIndex0
PerfIndex0
LogRemainingforUndoKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogScannedforUndoKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Total number of kilobytes of log that have been scanned by the new mirror server after failover.'
DetailLevel100
DisplayName'Log Scanned for Undo KB'
DisplayName009'Log Scanned for Undo KB'
HelpIndex0
PerfIndex0
LogScannedforUndoKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogSendFlowControlTimems property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Milliseconds log stream messages waited for send flow control in the last second.'
DetailLevel100
DisplayName'Log Send Flow Control Time (ms)'
DisplayName009'Log Send Flow Control Time (ms)'
HelpIndex0
PerfIndex0
LogSendFlowControlTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogSendQueueKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Total number of kilobytes of log that have not been sent to the mirror server'
DetailLevel100
DisplayName'Log Send Queue KB'
DisplayName009'Log Send Queue KB'
HelpIndex0
PerfIndex0
LogSendQueueKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ MirroredWriteTransactionsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of transactions which wrote to the mirrored database in the last second, that waited for log to be sent to the mirror.'
DetailLevel100
DisplayName'Mirrored Write Transactions/sec'
DisplayName009'Mirrored Write Transactions/sec'
HelpIndex0
PerfIndex0
MirroredWriteTransactionsPersec property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ PagesSentPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of pages sent per second'
DetailLevel100
DisplayName'Pages Sent/sec'
DisplayName009'Pages Sent/sec'
HelpIndex0
PerfIndex0
PagesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ ReceivesPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-1
Description'Number of mirroring message receives per second'
DetailLevel100
DisplayName'Receives/sec'
DisplayName009'Receives/sec'
HelpIndex0
PerfIndex0
ReceivesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ RedoBytesPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-5
Description'Number of bytes of log redone by the mirror database per second'
DetailLevel100
DisplayName'Redo Bytes/sec'
DisplayName009'Redo Bytes/sec'
HelpIndex0
PerfIndex0
RedoBytesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ RedoQueueKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Total number of kilobytes that redo on the mirror database is behind the hardened log'
DetailLevel100
DisplayName'Redo Queue KB'
DisplayName009'Redo Queue KB'
HelpIndex0
PerfIndex0
RedoQueueKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ SendPerReceiveAckTime property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Milliseconds messages waited for acknowledgement from the partner per second.'
DetailLevel100
DisplayName'Send/Receive Ack Time'
DisplayName009'Send/Receive Ack Time'
HelpIndex0
PerfIndex0
SendPerReceiveAckTime property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ SendsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of sends initiated per second'
DetailLevel100
DisplayName'Sends/sec'
DisplayName009'Sends/sec'
HelpIndex0
PerfIndex0
SendsPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionDelay property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of milliseconds transaction termination waited for acknowledgement per second.'
DetailLevel100
DisplayName'Transaction Delay'
DisplayName009'Transaction Delay'
HelpIndex0
PerfIndex0
TransactionDelay property is in 8 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring 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_SQLServerDatabaseMirroring Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
Description'This defines a Database Mirroring object for SQL Server'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:Database Mirroring'✓✗✓✓✓
DisplayName009'SQLServer:Database Mirroring'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseMirroring

Number of classes:1
Class nameChildsPropertiesMethodsClass
Instances
Child
Instances
AbstractSingleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring0300----
comments powered by Disqus
WUtils.com