--- title: "Database Mirroring Monitor Overview | Microsoft Docs" description: Learn how to use the Database Mirroring Monitor to monitor mirrored databases to verify data flow in the database mirroring session and for troubleshooting. ms.custom: "" ms.date: "03/07/2017" ms.prod: sql ms.prod_service: high-availability ms.reviewer: "" ms.technology: database-mirroring ms.topic: conceptual f1_keywords: - "sql13.swb.dbmmonitor.main.f1" helpviewer_keywords: - "Database Mirroring Monitor [SQL Server], interface" ms.assetid: 8ebbdcd6-565a-498f-b674-289c84b985eb author: MikeRayMSFT ms.author: mikeray --- # Database Mirroring Monitor Overview [!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)] If you have the correct permissions, you can use Database Mirroring Monitor to monitor any subset of the mirrored databases on a server instance. Monitoring enables you to verify whether and how well data is flowing in the database mirroring session. Database Mirroring Monitor is also useful for troubleshooting the cause of reduced data flow. You can register any of your mirrored databases for monitoring on each of the failover partners individually. When you register a database, Database Mirroring Monitor caches the following information about the database: - Database name - The names of the two partner server instances - The last known roles of each partner (principal or mirror) ## Permissions To monitor database mirroring, you must be a member of either the **sysadmin** fixed server role or the **dbm_monitor** fixed database role in the **msdb** database on the server instance. If you are a member of **sysadmin** or **dbm_monitor** on only one of the partner server instances, the monitor can connect only to that partner; the monitor cannot retrieve information from the other partner. If you are a member of just **dbm_monitor** on a server instance, you will have limited permissions on that server instance. You will only be able to view the most recent status row. If you connect to a server instance using **dbm_monitor** permissions, Database Mirroring Monitor informs you that you have limited permissions. > [!IMPORTANT] > The **dbm_monitor** fixed database role is created in the **msdb** database when the first database is registered in Database Mirroring Monitor. The new **dbm_monitor** role has no members until a system administrator assigns users to the role. ## Navigation Tree If any databases have been registered for monitoring by the Database Mirroring Monitor, a list of registered databases is displayed in the navigation tree. The tree automatically refreshes every 30 seconds. To see the status of a registered database, select it. For more information, see "Detail Pane," later in this topic. For each registered database, the following information is displayed: __ **(** _\_ **,** __ **->** __ **)** ** The name of a mirrored database that is registered with the Database Mirroring Monitor. *\* The possible statuses and their associated icons are as follows: |Icon|Status|Description| |----------|------------|-----------------| |Warning icon|**Unknown**|The monitor is not connected to either partner. The only available information is what has been cached by the monitor.| |Warning icon|**Synchronizing**|The contents of the mirror database are lagging behind the contents of the principal database. The principal server instance is sending log records to the mirror server instance, which is applying the changes to the mirror database to roll it forward.

At the start of a database mirroring session, the mirror and principal databases are in this state.| |Standard database cylinder|**Synchronized**|When the mirror server becomes sufficiently caught up to the principal server, the database state changes to **Synchronized**. The database remains in this state as long as the principal server continues to send changes to the mirror server and the mirror server continues to apply changes to the mirror database.

For high-safety mode, automatic failover and manual failover are both possible, without any data loss.

For high-performance mode, some data loss is always possible, even in the **Synchronized** state.| |Warning icon|**Suspended**|The principal database is available but is not sending any logs to the mirror server.| |Error icon|**Disconnected**|The server instance cannot connect to its partner.| ** The name of the partner that is currently the principal server instance. The name is in the following format: **[**\\**__] where ** is the name of the system on which the server instance resides. For a non-default server instance, the instance name is also displayed: __**\\**__. ** The name of the partner that is currently the mirror server instance. The format is the same as for the principal server. ## Detail Pane The appearance of the monitor depends on whether a database is selected. When you open the monitor, the detail pane displays a **Register mirrored database** link. Click this to register a database. Registered databases are listed below the **Database Mirroring Monitor** node in the navigation tree. Database Mirroring Monitor always tries to connect to every server instance for which it has stored credentials. When you select a database, its status is displayed on the **Status** tabbed page in the detail pane. The content of this page comes from both the principal and mirror server instances. The page is filled asynchronously as status is gathered through separate connections to the principal and mirror server instances. The status automatically refreshes at 30-second intervals. > [!NOTE] > You cannot change the monitor's refresh rate, but you can refresh the status table from the **Database Mirroring History** dialog box. A system administrator can view the current configuration of warnings for the database by selecting the **Warnings** tabbed page. From there, the administrator can launch the **Set Warning Thresholds** dialog box to enable and configure one or more warning thresholds. In the banner above the tabs, the detail pane displays the last time the monitor refreshed the status information as, **Last refresh:**_\\