Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sensible values for Database Mirroring Monitor Threshold Expand / Collapse
Author
Message
Posted Monday, October 8, 2012 4:50 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:56 AM
Points: 598, Visits: 1,612
Hi all

As the title suggests I am wondering what other people are using as thresholds for database mirroing. We have a multi-site mirror which is connected by fibre cable roughly 100 yards away, and the system is low transactional.

With that in mind what do people consider a sensible threshold for unsent log, unrestored log, oldest unsent transaction and mirror commit overhead?

Thanks for your suggestions.
Post #1369711
Posted Monday, October 8, 2012 5:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:50 AM
Points: 6,358, Visits: 13,688
Kwisatz78 (10/8/2012)
Hi all

As the title suggests I am wondering what other people are using as thresholds for database mirroing. We have a multi-site mirror which is connected by fibre cable roughly 100 yards away, and the system is low transactional.

With that in mind what do people consider a sensible threshold for unsent log, unrestored log, oldest unsent transaction and mirror commit overhead?

Thanks for your suggestions.

Are you referring to the default timeout value?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1369728
Posted Monday, October 8, 2012 6:02 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:56 AM
Points: 598, Visits: 1,612
Hi Perry

I am referring to the thresholds you can set in the Database Mirroring Monitor itself, which I want to configure SCOM to alert on. Table 1 in the following link shows the event IDs, but I was just wondering what values are sensible to use for these thresholds.

http://technet.microsoft.com/en-us/library/cc966392.aspx

Thanks
Post #1369745
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse