Monitoring SQL Server database mirroring [graphic]_mssql2005

1. First, open SMS, right click on any database, task, start Database Mirroring Monitor.

2. Click the Register mirror database, in the server Instance drop-down menu, select the mirror database instance name, if not, you can directly point to the connection, and then in the link to the server window to set, as shown in the following figure:

3. After setting up the point to determine the following window appears as shown:

4. Click on the Warning tab to set the threshold value for the warning, as shown in the following illustration:

5. Click history on the window of step 3 to see the history of SQL Server database mirroring running. As shown in the following illustration: