Skip to Content

DB Mirroring

Hi all,

we are going to install DB mirroring for ECC6.0 EHP6 , Here I have questions.

1. what are the performance issues when we configure in synchronous mode

2. Is mirroring server automatically starts when primary server went down. If it is not available how to achieve this.

Environment: Windows 2008 R2

SAP: ECC6 EHP6

DB: MS SQL Server 2008 R2

Thanks in advance.

Regards

Suresh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 17, 2016 at 04:07 AM

    Hi Suresh,

    1) With synchronous mirroring, the primary server only confirms the transaction after the acknowledge from the mirrored server is received. Considering that both IO subsystem and network bandwidth/distance of primary and mirrored are well taken care, still there can be delays in database updates (and possibly batches). Dialog is not much affected, because the way SAP ABAP AS works with asynchronous database updates.JAVA on the other hand can be affected, because the logic is different.

    2) You have to decide to use synchronous mirroring with automatic failover or not.

    I personally suggest you to upgrade your database to at least SQL Server 2012 and go for AlwaysOn. SQL Server 2008 R2 is 6 years old and there are 3 releases ahead of him (2012, 2014 and 2016). If you are to spent some effort with building a HADR solution, it would be better to build one that is currently supported, because as of SQL Server 2012, Database mirroring has been deprecated by Microsoft and might be removed in a future version.

    You can get more details from Database Mirroring in the SAP on SQL Server whitepaper recently released at MSDN.

    The following notes are also helpful:

    1772688 - SQL Server AlwaysOn and SAP applications

    965908 - SQL Server Database Mirroring and SAP Applications

    Best regards,

    Luis Darui

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.