New Article on SQLPerformance.com: "Avoid HA/DR Solution Self-Delusion"

My sixth guest blog post was published today on SQLPerformance.com: Avoid HA/DR Solution Self-Delusion This article gives a few examples of how we can delude ourselves into thinking that a solution is fully meeting our high availability and disaster recovery requirements.

Should you ignore DBMIRROR_DBM_MUTEX?

The DBMIRROR_DBM_MUTEX wait type is undocumented. Or rather, it is documented in books online as being “Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.” Paul Randal had some additional information on this wait type in his “Wait statistics, or please tell me where it hurts” post, defining the wait type as […]