Hi all. Here is my situation.
We have a 24 x 7 production system which is mirrored with high safety mode, and every night we have a job to defragment all indexes (at nights it slightly less accessed than during the day). Cumulative size of all principal databases is 2 TB+.
Due to large amount of indexes rebuilt our mirroring does not keep up with rebuilding causing in turn mirroring delays. Since it is in high safety mode, it holds blocks on resources waiting for each transaction to acknowledgement from the mirror side, creating many blockings and timeouts.
Does anybody experience same problems? What would be best solution to it ? Does changing mirroring from high safety to high performance mode solves this problem? What implications it can cause?
Our SQL Server version is 2008 R2, and we use mirroring mostly for disaster recovery; we have failover clustering for high availability.
Thanks