Groups > comp.databases.ms-sqlserver > #1856

SQL 2012 Database Mirroring Issue is stalling

Newsgroups	comp.databases.ms-sqlserver
Date	2015-01-16 19:57 -0800
Message-ID	<976c395d-6b1c-40c3-9d8a-19eae48a1b97@googlegroups.com> (permalink)
Subject	SQL 2012 Database Mirroring Issue is stalling
From	Query Builder <querybuilder@gmail.com>

Show all headers | View raw

hi All, 

I have a SQL 2012 Enterprise Primary and DR SQL Clusters. 
I have a 500 GB TDE Enabled Using HSM SQL DB which I have mirrored across to DR.

I am noticing that my Logs are shipping to DR, but the Unrestored Log size is huge and My restore rate is about 0 - 80KB/Sec. This is Causing the unrestored Log to grow on the DR side. 

I also notice at times my Unsent Log is also getting big after any DB Maintenance activities (such as rebuild of indexes). 

I have a dedicated connection between my datacenters and the traffic thruput is quite reasonable and I am able to copy out a 2GB File across within a few minutes. I see no packet drops within my links. 

How do I ensure that my unsent logs are copied out and also increase my restore rate in DR side. 

Any help / Suggestions will be much appreciated.  

Regards
Aravin Rajendra.

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

SQL 2012 Database Mirroring Issue is stalling Query Builder <querybuilder@gmail.com> - 2015-01-16 19:57 -0800
  Re: SQL 2012 Database Mirroring Issue is stalling Erland Sommarskog <esquel@sommarskog.se> - 2015-01-17 10:55 +0100

csiph-web