Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
DR requirement

已答覆 DR requirement

  • Wednesday, February 13, 2013 7:09 PM
     
     
    Sign In to Vote
    0

    Hi Experts,

    Needed guidance if you would suggest setting up async mirroring on VLDB say 5 TB SAP OLTP warehouse database having roughly 700 GB of changes everyday.

    Any Links pertaining to the same would be helpful.

    Cheers

    Samy

     

All Replies

  • Wednesday, February 13, 2013 7:16 PM
     
     
    Sign In to Vote
    0

    Hi Experts,

    Needed guidance if you would suggest setting up async mirroring on VLDB say 5 TB SAP OLTP warehouse database having roughly 700 GB of changes everyday.

    Any Links pertaining to the same would be helpful.

    Cheers

    Samy

     
  • Wednesday, February 13, 2013 9:44 PM
     
     
    Sign In to Vote
    0
    The only way to know if it will work is to test before going into production. You would specifically need to monitor I/O and network.

    Allan Hirt Blog: http://www.sqlha.com/blog Coming in 2013: Mission Critical SQL Server 2012 - the followup to Pro SQL Server 2008 Failover Clustering

     
  • Wednesday, February 13, 2013 9:54 PM
     
     Answered
    Sign In to Vote
    0
    700 GB of Change a day is quite a lot, but definetly doable. Allan already pointed out the key Areas: I/O and Network. One more Thing here: You should only do this with Enterprise Edition SQL. Otherwise you might run into a bottleneck within the Redo thread.
     
  • Wednesday, February 13, 2013 10:05 PM
     
     
    Sign In to Vote
    0
    I think this thread is a double... Let's Keep the answers in the one that is in the HA & DR Forum, shall we?
     
  • Thursday, February 14, 2013 2:17 AM
     
     
    Sign In to Vote
    0

    Thanks , but does the Size the database impact the mirroring setup in any case.

    Cheers

    Samy

     
  • Thursday, February 14, 2013 5:21 AM
     
     Answered
    Sign In to Vote
    0

    size is not the issue to set up the mirroring.

    Allen & prince are taking about the performance due to massive amount of data transfer between principal and secondary.

    you have to take good care of I/O and network. And MOde of mirroring.

     
  • Thursday, February 14, 2013 6:08 AM
     
     
    Sign In to Vote
    0
    Thanks Kumar,  I do understand the same. It would be helpful if there is any case study\Link there for reference for setting up Async mirroring on databases of 5 TB with heavy load on them.
     
  • Tuesday, February 19, 2013 6:27 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Samy,

    Please read the following documents before setting up database mirroring since there are lots of data need to be transferred.

    Things to consider when setting up database mirroring in SQL Server.
    http://support.microsoft.com/kb/2001270#hdd

    Setting Up Database Mirroring (SQL Server)
    http://msdn.microsoft.com/en-us/library/ms190941.aspx

    Allen Li
    TechNet Community Support