Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica, ROOT\CIMV2

Class | Methods | Properties (20) | Qualifiers (12) | 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_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica properties

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica has 20 properties (11 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
FileBytesReceivedPersecWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LogBytesReceivedPersecWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
LogremainingforundoWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
LogSendQueueWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
MirroredWriteTransactionsPersecWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
RecoveryQueueWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
RedoblockedPersecWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
RedoBytesRemainingWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
RedoneBytesPersecWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TotalLogrequiringundoWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]
TransactionDelayWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica properties

Local properties (11) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica class

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

NameValueToInstanceToSubclassOverridableAmendedLocal
Description'This defines a HADR secondary database object for SQL Server'
DetailLevel100
DisplayName'MSSQL$MICROSOFT##WID:Database Replica'
DisplayName009'MSSQL$MICROSOFT##WID:Database Replica'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQL$MICROSOFT##WID'

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT20___SYSTEM3
__RELPATH'Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8
__CLASS'Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDDatabaseReplica

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