The Cost Of Synchronous Mirroring

About a month or so ago, I started dealing with a customer's performance issues.  When I checked the wait stats using Glenn Berry's fantastic set of DMV queries, I noticed that 99% of wait stats were around mirroring.  This says that 99% of the time that SQL Server spends waiting to run queries is due to the…

Advertisement