locked
Master Data Services 2012 RRS feed

  • Question

  • Best Practice Question:

    Is it best practice to install MDS [Master Data Services] on the Database server or a dedicated IIS server?  Thinking the workload for MDS will be minimal, but seems would be best practice to have it installed on a dedicated server.  any input would be appreciated.

    Thursday, September 12, 2013 12:46 AM

Answers

  • Master Data is not that big usually to be on a separate server

    and the main component of MDS is the underlying database of it, it would require scheduled backup and all considerations of operational databases. So I would say that It is better to use Database server for MDS installation. The WebUI can be installed on the web server. but then you would require to have good and reliable connection between web server and database server.


    Regards,

    Reza

    SQL Server MVP

    Blog:   http://rad.pasfu.com  Twitter:   LinkedIn:

    SQL Server Integration Services 2012 Tutorial Videos:     http://www.radacad.com/CoursePlan.aspx?course=1

    • Marked as answer by Edward Sora Thursday, September 12, 2013 1:06 AM
    Thursday, September 12, 2013 1:03 AM

All replies

  • Master Data is not that big usually to be on a separate server

    and the main component of MDS is the underlying database of it, it would require scheduled backup and all considerations of operational databases. So I would say that It is better to use Database server for MDS installation. The WebUI can be installed on the web server. but then you would require to have good and reliable connection between web server and database server.


    Regards,

    Reza

    SQL Server MVP

    Blog:   http://rad.pasfu.com  Twitter:   LinkedIn:

    SQL Server Integration Services 2012 Tutorial Videos:     http://www.radacad.com/CoursePlan.aspx?course=1

    • Marked as answer by Edward Sora Thursday, September 12, 2013 1:06 AM
    Thursday, September 12, 2013 1:03 AM
  • thanks for the input Reza
    Thursday, September 12, 2013 1:07 AM