In my survey for this week, I'd like to know what you monitor if you're using database mirroring.
[Edit: The survey has closed now. See here for the results.]
I'll report on the results during the first week of February.
Thanks!
A prior student emailed me yesterday about some strange behavior of the sample_ms column in sys.dm_io_virtual_file_stats. It’s supposed to be the number of milliseconds since the SQL
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
Ten years ago today we announced that we were hiring our first employee: Jonathan Kehayias. It was a big risk for Kimberly and I, as
(This is also the Ponderings – editorial – in today’s SQLskills newsletter.) I want to start out this post by sincerely thanking everyone who emailed
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.
2 thoughts on “Survey: monitoring database mirroring”
Before we had to move away from Mirroring due to "Stability under load" issues, I was monitoring the SEND, REDO queues along with Commit Overhead. Most of the monitoring was performed via extended events for when we exceeded expected maximums and interactive monitoring via the Database Mirroring Monitor.
We were configured as synchronous, automatic fail-over, and with a witness.
Robert Miller