Skip to Content

Production System with 2 MS SQL Db Engine but one single Disk

Dear Comunity,

in your opinion on a production system it is possible to install 2 MS SQL Engine (one for each instance, not 1 engine with 2 instances) having only one disk for both DB SAP instances?

Thanks in advace.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on 5 days ago

    Hi Frank.

    Yes, it is possible, but in production environment it is not advisable, better create two different VMs and then achieve your requirement.

    Regards

    SS

    Add a comment
    10|10000 characters needed characters exceeded

    • Thank you for your feedback, unfortunately I can't create vm, I'm looking for some sap notes that recommend or oblige me to use separate servers or at least separate disks for each instance, so as to be able to justify "the risk", but I can't find anything on SAP portal.

  • Posted on 3 days ago

    Hi Frank.

    I am not sure about the SAP Note, better you can raise the support ticket to SAP for this, they may help you.

    Refer to this Whitepaper SAP on SQL Server link

    https://docs.microsoft.com/en-gb/archive/blogs/saponsqlserver/whitepaper-sap-on-sql-server-2012-and-sql-server-2014

    Regards

    SS

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on 2 days ago

    Hi Frank,

    yes, you can do it, but

    • the performance will be really bad if you put both databases on one disk, it is not even recommended to have one DB one just one disk, but two DBs will be worse
    • you create a single point of failure for both databases, means when this disk fails you will loose both databases

    But at the end it is your system, SAP has no rules on how to spread your databases over disks, the recommendations can be read in the whitepaper mentioned.

    Best regards

    Clas Hortien

    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.