Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica, ROOT\CIMV2
Class
| Methods | Properties (20)
| Qualifiers (12)
| Instances (1)
| Namespaces (1)
VB Script
| C#
| VB.Net
| Search on:Microsoft
Description This defines a HADR secondary database object for SQL Server
Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica properties Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica has 20 properties (11 Local , 9 Derived )
Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica properties Local properties (11) of Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica class ▲ FileBytesReceivedPersec propertyCIMTYPE 'uint64' CounterType 272696576 DefaultScale -4 Description 'Amount of filestream data received by the availability replica for the database' DetailLevel 100 DisplayName 'File Bytes Received/sec' DisplayName009 'File Bytes Received/sec' HelpIndex 0 PerfIndex 0 FileBytesReceivedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogBytesReceivedPersec propertyCIMTYPE 'uint64' CounterType 272696576 DefaultScale -4 Description 'Amount of logs received by the availability replica for the database' 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
▲ Logremainingforundo propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'The amount of log in kilobytes remaining to finish the undo phase.' DetailLevel 100 DisplayName 'Log remaining for undo' DisplayName009 'Log remaining for undo' HelpIndex 0 PerfIndex 0 Logremainingforundo property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ LogSendQueue propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'Amount of logs in kilobytes that is waiting to be send to the database replica' DetailLevel 100 DisplayName 'Log Send Queue' DisplayName009 'Log Send Queue' HelpIndex 0 PerfIndex 0 LogSendQueue 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
▲ RecoveryQueue propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'Total number of hardened log in kilobytes that is waiting to be redone on the secondary' DetailLevel 100 DisplayName 'Recovery Queue' DisplayName009 'Recovery Queue' HelpIndex 0 PerfDefault True PerfIndex 0 RecoveryQueue property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ RedoblockedPersec propertyCIMTYPE 'uint64' CounterType 272696576 DefaultScale 0 Description 'Number of times redo gets blocked in the last second' DetailLevel 100 DisplayName 'Redo blocked/sec' DisplayName009 'Redo blocked/sec' HelpIndex 0 PerfIndex 0 RedoblockedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ RedoBytesRemaining propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'The amount of log in kilobytes remaining to be redone to finish the reverting phase.' DetailLevel 100 DisplayName 'Redo Bytes Remaining' DisplayName009 'Redo Bytes Remaining' HelpIndex 0 PerfIndex 0 RedoBytesRemaining property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ RedoneBytesPersec propertyCIMTYPE 'uint64' CounterType 272696576 DefaultScale -4 Description 'Amount of log records redone in the last second to catch up the database replica' DetailLevel 100 DisplayName 'Redone Bytes/sec' DisplayName009 'Redone Bytes/sec' HelpIndex 0 PerfIndex 0 RedoneBytesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ TotalLogrequiringundo propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale 0 Description 'The amount of log in kilobytes that need to be undone.' DetailLevel 100 DisplayName 'Total Log requiring undo' DisplayName009 'Total Log requiring undo' HelpIndex 0 PerfIndex 0 TotalLogrequiringundo property is in 4 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_SQLServerDatabaseReplica 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_SQLServerDatabaseReplica Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local Description 'This defines a HADR secondary database object for SQL Server' ✓ ✗ ✓ ✓ ✓ DetailLevel 100 ✓ ✗ ✓ ✗ ✓ DisplayName 'SQLServer:Database Replica' ✓ ✗ ✓ ✓ ✓ DisplayName009 'SQLServer:Database Replica' ✓ ✗ ✓ ✗ ✓ dynamic True ✓ ✗ ✓ ✗ ✓ GenericPerfCtr True ✓ ✗ ✓ ✗ ✓ HelpIndex 0 ✓ ✗ ✓ ✗ ✓ HiPerf True ✓ ✗ ✓ ✗ ✓ Locale 1033 ✓ ✗ ✓ ✓ ✓ PerfIndex 0 ✓ ✗ ✓ ✗ ✓ provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓ RegistryKey 'MSSQLSERVER' ✓ ✗ ✓ ✗ ✓
Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica System properties Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by