home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,136 of 19,505   
   Query Builder to All   
   SQL 2012 Database Mirroring Issue is sta   
   16 Jan 15 19:57:37   
   
   From: querybuilder@gmail.com   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca