• Management Pack:  SQL Server 2012
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

SQL 2012 Mirroring Group Class

  • ID:  Microsoft.SQLServer.2012.Mirroring.Group
  • Description:  Microsoft SQL Server 2012 Mirroring Group
  • Class Hierarchy: 
    Entity
    Logical Entity
    Computer Role
    SQL 2012 Mirroring Group

  • Attributes:  Public, Non-Hosted
Login
Monitors the auto close setting for the database Monitors the auto create statistic setting for the database Monitors the auto shrink setting for the database Monitors the auto update statistics async setting for the database Monitors the auto update statistics setting for the database Monitors the DB chaining setting for the database Monitors the trustworthy setting for the database Monitors the page verify setting for the database. Monitors the recovery model setting for the database. Monitors for a large change in value of database free space over a set number of sample periods. Monitors the space available in the database and on the media hosting the database in percentage terms. Note that this monitor does not count free space for FILESTREAM Filegroups. Transaction Log Free Space (%) monitor for 2012 Databases. This monitor checks if database mirror is synchronized. This monitor checks if database mirror witness is accessible. This monitor checks the status of the database as reported by Microsoft® SQL Server™. This monitor checks the status of the SQL Database Engine service. This monitor checks the status of the database backup as reported by Microsoft® SQL Server™. Note that the monitor ignores Always On databases. Therefore, it is always 'green' for those databases. For backups of Always On databases, use the dedicated monitors at the Availability Group. This monitor detects when a log shipping destination has not had a log restored to it within the threshold defined as a part of the log shipping configuration. Note that all Log Shipping is not supported by any edition of SQL Server Express. This monitor detects when a log shipping source has not had its logs backed up within the threshold defined as a part of the log shipping configuration. Note that all Log Shipping is not supported by any edition of SQL Server Express. Disk Read Latency monitor for 2012 Databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. Disk Write Latency monitor for 2012 Databases. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. This monitor checks if database mirror is synchronized. Microsoft SQL Server 2012 Mirroring Group Microsoft SQL Server 2012 Mirrored Database Microsoft SQL Server 2012 Mirrored Database Witness

Download diagram as a Visio file

Properties

Display Name Description
Database Name  
Display Name Display name of monitoring object.
Mirror Computer Name  
Mirror SQL Instance Name  
Mirroring GUID (Key)  
Mirroring Level  
Principal Computer Name  
Principal SQL Instance Name  

Discovered By

Name Description
Discover Mirrored Databases for a Database Engine This object discovery discovers all mirrored databases running for a given instance of SQL Server 2012 DB Engine. By default, all mirrored databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or * wildcard to exclude all databases.
Discover Mirrored Databases Witnesses This object discovery discovers all mirrored databases witnesses running for a given instance of SQL Server 2012 DB Engine. By default witnesses for all mirrored databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or * wildcard to exclude all databases.

Relations

Health Source
NameClassType
Microsoft SQL Server 2012 Mirroring Group contains Mirrored Database SQL 2012 Mirroring Group Membership
Microsoft SQL Server 2012 Mirroring Group contains Mirrored Database Witness SQL 2012 Mirroring Group Membership
Entity Watched By Perspective Entity Reference

Health Target
NameClassType
Microsoft SQL Server 2012 Mirroring Service contains Mirroring Group SQL 2012 Mirroring Group Membership
Common Mirroring Group Contains Mirroring Group SQL 2012 Mirroring Group Membership
SQL Server 2012 Mirroring Groups Group Contains Mirroring Group SQL 2012 Mirroring Group Membership

Class Knowledgebase

Summary
This class does not contain any summary.
External References
This class does not contain any external references.

See Also for SQL Server 2012 Management Pack


Downloads for SQL Server 2012 Management Pack

Back to top
AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED