WUtils.com

Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica, ROOT\CIMV2

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

Description

This defines a HADR secondary database object for SQL Server

Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica has 20 properties (11 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
FileBytesReceivedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LogBytesReceivedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
LogremainingforundoWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
LogSendQueueWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
MirroredWriteTransactionsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
RecoveryQueueWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
RedoblockedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
RedoBytesRemainingWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
RedoneBytesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TotalLogrequiringundoWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]
TransactionDelayWin32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica properties

Local properties (11) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica class

…
▲ FileBytesReceivedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'FileBytesReceivedPersec'
CounterType272696576
Description'Amount of filestream data received by the availability replica for the database'
DisplayName'File Bytes Received/sec'
DisplayName009'File Bytes Received/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
FileBytesReceivedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogBytesReceivedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LogBytesReceivedPersec'
CounterType272696576
Description'Amount of logs received by the availability replica for the database'
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
…
▲ Logremainingforundo property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Logremainingforundo'
CounterType65792
Description'The amount of log in kilobytes remaining to finish the undo phase.'
DisplayName'Log remaining for undo'
DisplayName009'Log remaining for undo'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Logremainingforundo property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogSendQueue property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'LogSendQueue'
CounterType65792
Description'Amount of logs in kilobytes that is waiting to be send to the database replica'
DisplayName'Log Send Queue'
DisplayName009'Log Send Queue'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LogSendQueue 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
…
▲ RecoveryQueue property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'RecoveryQueue'
CounterType65792
Description'Total number of hardened log in kilobytes that is waiting to be redone on the secondary'
DisplayName'Recovery Queue'
DisplayName009'Recovery Queue'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RecoveryQueue property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ RedoblockedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'RedoblockedPersec'
CounterType272696576
Description'Number of times redo gets blocked in the last second'
DisplayName'Redo blocked/sec'
DisplayName009'Redo blocked/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RedoblockedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ RedoBytesRemaining property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'RedoBytesRemaining'
CounterType65792
Description'The amount of log in kilobytes remaining to be redone to finish the reverting phase.'
DisplayName'Redo Bytes Remaining'
DisplayName009'Redo Bytes Remaining'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RedoBytesRemaining property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ RedoneBytesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'RedoneBytesPersec'
CounterType272696576
Description'Amount of log records redone in the last second to catch up the database replica'
DisplayName'Redone Bytes/sec'
DisplayName009'Redone Bytes/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RedoneBytesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TotalLogrequiringundo property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'TotalLogrequiringundo'
CounterType65792
Description'The amount of log in kilobytes that need to be undone.'
DisplayName'Total Log requiring undo'
DisplayName009'Total Log requiring undo'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
TotalLogrequiringundo property is in 4 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_SQLServerDatabaseReplica 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_SQLServerDatabaseReplica Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica'✓✗✓✗✓
CookedTrue✓✗✓✗✓
Description'This defines a HADR secondary database object for SQL Server'✓✗✓✓✓
DisplayName'SQLServer:Database Replica'✓✗✓✓✓
DisplayName009'SQLServer:Database Replica'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabaseReplica

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