Q1) Can I use IP addresses instead of server names when using the DBM Monitor?

A1) Unfortunately not.

Q2) Is there any in-built throttling mechanism in DBM to allow the mirror to catch-up when synchronizing a synchronous mirroring session?

A2) Yes, if there’s more than 1MB of transaction log on the principal that hasn’t been sent to the mirror, the mirroring session state will be switched from SYNCHRONIZED to SYNCHRONIZING and the principal itself will start adding a few milliseconds delay to transaction commits until the amount of unsent log drops below 1MB

Q3) Are there any tips when setting up a mirroring session using backups?

A3) Yes, make sure that all the backups are restored WITH NORECOVERY on the mirror. The database has to be unrecovered otherwise the mirroring session cannot start and you’re back to square one with restoring the mirror database.

Q4) What are the performance considerations with DBM – both in terms of the impact on the application workload and on DBM itself?

2 Responses to Conference Questions Pot-Pourri #2: Database mirroring

Is there any way to find when the database mirroring was broken and by whom. I am facing this issue with senior managements and Auditors as to who and when the mirroring was broken.
Funny part is the Alerting tool did not capture the breaking of mirroring and i am not able to find any information in the error log or the Windows Event viewer.
Not sure if i was looking at wrong place.
Is there other place where the information could be stored.

It’ll be in the transaction log because there is a state change that’s logged. I don’t have a mirroring configuration right now so you’ll need to investigate yourself. Once you identify the transaction, you can use the Transaction SID and suser_sname to figure out who did it.