X-Received: by 10.66.65.169 with SMTP id y9mr4557814pas.21.1421467058460; Fri, 16 Jan 2015 19:57:38 -0800 (PST) X-Received: by 10.140.104.166 with SMTP id a35mr468qgf.20.1421467058148; Fri, 16 Jan 2015 19:57:38 -0800 (PST) Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!h15no6836508igd.0!news-out.google.com!n9ni489qai.0!nntp.google.com!v8no1567862qal.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-sqlserver Date: Fri, 16 Jan 2015 19:57:37 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=199.107.28.251; posting-account=PgKd2woAAADMEPoOHlv-FZYtrlmqlSnd NNTP-Posting-Host: 199.107.28.251 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <976c395d-6b1c-40c3-9d8a-19eae48a1b97@googlegroups.com> Subject: SQL 2012 Database Mirroring Issue is stalling From: Query Builder Injection-Date: Sat, 17 Jan 2015 03:57:38 +0000 Content-Type: text/plain; charset=ISO-8859-1 Xref: csiph.com comp.databases.ms-sqlserver:1856 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.