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)

NameOriginCIMType
BytesReceivedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
BytesSentPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LogBytesReceivedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogBytesRedonefromCachePersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogBytesSentfromCachePersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogBytesSentPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogCompressedBytesRcvdPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogCompressedBytesSentPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogHardenTimemsWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogRemainingforUndoKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogScannedforUndoKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogSendFlowControlTimemsWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
LogSendQueueKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
MirroredWriteTransactionsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
PagesSentPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
ReceivesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
RedoBytesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
RedoQueueKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
SendPerReceiveAckTimeWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
SendsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TransactionDelayWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring properties

Local properties (21) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring class

▲ BytesReceivedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'BytesReceivedPersec'
CounterType272696576
Description'Number of bytes received per second'
DisplayName'Bytes Received/sec'
DisplayName009'Bytes Received/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
BytesReceivedPersec property is in 40 classes of ROOT\cimv2 and in 1 namespace
▲ BytesSentPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'BytesSentPersec'
CounterType272696576
Description'Number of bytes sent per second'
DisplayName'Bytes Sent/sec'
DisplayName009'Bytes Sent/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
BytesSentPersec property is in 30 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesReceivedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogBytesReceivedPersec'
CounterType272696576
Description'Number of bytes of log received per second'
DisplayName'Log Bytes Received/sec'
DisplayName009'Log Bytes Received/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogBytesReceivedPersec property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesRedonefromCachePersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogBytesRedonefromCachePersec'
CounterType272696576
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'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogBytesRedonefromCachePersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesSentfromCachePersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogBytesSentfromCachePersec'
CounterType272696576
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'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogBytesSentfromCachePersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesSentPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogBytesSentPersec'
CounterType272696576
Description'Number of bytes of log sent per second'
DisplayName'Log Bytes Sent/sec'
DisplayName009'Log Bytes Sent/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogBytesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogCompressedBytesRcvdPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogCompressedBytesRcvdPersec'
CounterType272696576
Description'Number of compressed bytes of log received in the last second.'
DisplayName'Log Compressed Bytes Rcvd/sec'
DisplayName009'Log Compressed Bytes Rcvd/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogCompressedBytesRcvdPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogCompressedBytesSentPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogCompressedBytesSentPersec'
CounterType272696576
Description'Number of compressed bytes of log sent in the last second.'
DisplayName'Log Compressed Bytes Sent/sec'
DisplayName009'Log Compressed Bytes Sent/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogCompressedBytesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogHardenTimems property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogHardenTimems'
CounterType272696576
Description'Milliseconds log blocks waited to be hardened to disk in the last second.'
DisplayName'Log Harden Time (ms)'
DisplayName009'Log Harden Time (ms)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogHardenTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogRemainingforUndoKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'LogRemainingforUndoKB'
CounterType65792
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'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogRemainingforUndoKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogScannedforUndoKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'LogScannedforUndoKB'
CounterType65792
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'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogScannedforUndoKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogSendFlowControlTimems property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogSendFlowControlTimems'
CounterType272696576
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)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogSendFlowControlTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogSendQueueKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'LogSendQueueKB'
CounterType65792
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'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogSendQueueKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ MirroredWriteTransactionsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'MirroredWriteTransactionsPersec'
CounterType272696576
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'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
MirroredWriteTransactionsPersec property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ PagesSentPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PagesSentPersec'
CounterType272696576
Description'Number of pages sent per second'
DisplayName'Pages Sent/sec'
DisplayName009'Pages Sent/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PagesSentPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ ReceivesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ReceivesPersec'
CounterType272696576
Description'Number of mirroring message receives per second'
DisplayName'Receives/sec'
DisplayName009'Receives/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ReceivesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ RedoBytesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'RedoBytesPersec'
CounterType272696576
Description'Number of bytes of log redone by the mirror database per second'
DisplayName'Redo Bytes/sec'
DisplayName009'Redo Bytes/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RedoBytesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ RedoQueueKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'RedoQueueKB'
CounterType65792
Description'Total number of kilobytes that redo on the mirror database is behind the hardened log'
DisplayName'Redo Queue KB'
DisplayName009'Redo Queue KB'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RedoQueueKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ SendPerReceiveAckTime property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'SendPerReceiveAckTime'
CounterType272696576
Description'Milliseconds messages waited for acknowledgement from the partner per second.'
DisplayName'Send/Receive Ack Time'
DisplayName009'Send/Receive Ack Time'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
SendPerReceiveAckTime property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ SendsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'SendsPersec'
CounterType272696576
Description'Number of sends initiated per second'
DisplayName'Sends/sec'
DisplayName009'Sends/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
SendsPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ TransactionDelay property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'TransactionDelay'
CounterType272696576
Description'Number of milliseconds transaction termination waited for acknowledgement per second.'
DisplayName'Transaction Delay'
DisplayName009'Transaction Delay'
HelpIndex0
PerfIndex0
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

▲ 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_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring Qualifiers

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

Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseMirroring

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