Database Mirroring Monitor

Question

I am trying to figure out how I should set up the thresholds for the principle and mirror.  Are there some basic guidelines?  Are there any recommendations?

---

lcerni

Answer 1

Pls check this http://msdn.microsoft.com/en-us/library/ms408393.aspx

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

check this link

http://msdn.microsoft.com/en-us/library/ms190030.aspx

Answer 3

If I run this in SQL Server Management Studio, do I need to go into the Database Mirroring Monitor and alter the thresholds there?

EXEC msdb.dbo.sp_add_alert @name=N'DBM Perf: Unsent Log Threshold',
  @message_id=32042,
  @severity=0,
  @enabled=1,
  @delay_between_responses=1800,
  @include_event_description_in=1,
  @category_name=N'Database Mirroring',
  @job_id=N'00000000-0000-0000-0000-000000000000'

---

lcerni

Answer 4

You can do it either way - 

---

http://uk.linkedin.com/in/ramjaddu

Answer 5

I thought that for the SQL Server Alert to work you need to set up the thresholds in the Database Mirroring Monitor? 

I thought that the alert (msdb.dbo.sp_add_alert) will flag when the performance thresholds (which are logged to the Windows event log) are exceeded.

---

lcerni

Answer 6

Hi Icerni,

To set up and manage monitoring for one or more of the mirrored databases on a server instance, you can use either Database Mirroring Monitor or the dbmmonitor system stored procedures. Specifically, monitoring a mirrored database enables you to: Set warning thresholds on key performance metrics.

In Database Mirroring Monitor, the administrator can view the current configuration of warnings for a selected database at both the principal and mirror server instances at the same time by selecting the Warnings tabbed page. From there, the administrator can open the Set Warning Thresholds dialog box to enable and configure one or more warning thresholds.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 7

First Database

6920601 KB                   6920601 KB
6920601 KB                   6920601 KB
15 min                           15 min
Not Enabled                   Not enabled

 

Second Database

1281556 KB                   1281556 KB
1281556 KB                   1281556 KB
15 min                            15 min
Not Enabled                   Not enabled

 

This is how we set it up.
We took the log size and multiply by 1.01

---

lcerni