Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


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

Re: SQL 2012 Database Mirroring Issue is stalling

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From Erland Sommarskog <esquel@sommarskog.se>
Newsgroups comp.databases.ms-sqlserver
Subject Re: SQL 2012 Database Mirroring Issue is stalling
Date Sat, 17 Jan 2015 10:55:10 +0100
Organization Erland Sommarskog
Lines 22
Message-ID <XnsA4256F145EF11Yazorman@127.0.0.1> (permalink)
References <976c395d-6b1c-40c3-9d8a-19eae48a1b97@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset=windows-1252
Content-Transfer-Encoding 8bit
Injection-Info mx02.eternal-september.org; posting-host="416ef8a880b1e4f6f96e9a7c39a8d7a9"; logging-data="2194"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/v8rxfHfYytRWl9TAKWFqY"
User-Agent Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock sha1:+wrjHBbW67ZulOyqXQ9grmj4B2k=
Xref csiph.com comp.databases.ms-sqlserver:1857

Show key headers only | View raw


Query Builder (querybuilder@gmail.com) writes:
> 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. 

And in that case, it is not much of a DR site. :-(

This is not really my area, so I don't have an answer, but I see that you 
have also posted this question to
https://social.technet.microsoft.com/Forums/en-US/884fc9d7-28a6-46ae-96b2-
8fc3d3ba9ccc/sql-2012-database-mirroring-issue-is-
stalling?forum=sqlreplication

It's the wrong forum, but supposedly a moderator will move to the Database 
Engine forum.


-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | NextPrevious 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