locked
How scalable is SQL Server MDS? Has anyone worked with both MDS and MultiVue from VisionWare? RRS feed

  • Question

  • We have been responsible for implementing a number of instances of VisionWare MultiVue for several Local Authority clients.

    We are now quoting for another Local Authority client and I would prefer to propose Microsoft MDS so that we can maintain a consistent tool set.

    Is anyone aware of the differences between MultiVue and MDS? In particular, would MDS and its associated tools be as scalable as MultiVue? We would need control around 1000000 people with 100000 addresses.

    Thanks very much for your help ...

    Rob

    Monday, March 7, 2016 10:11 AM

Answers

  • http://social.technet.microsoft.com/wiki/contents/articles/7812.master-data-services-capacity-guidelines.aspx

    The current MDS release 2012/2014, would support up to 10 million members per entity.

    In the SQL Server 2016, we significantly improve on performance and capacity. The new capacity guideline haven't been released yet.

    But in either version, MDS should handle the 1m gracefully.

    However, besides the size of the model, the specific user scenario/pattern also matter. You may want to build a prototype or proof of concept to test whether it works.

    I highly recommend to try SQL Server 2016 RC1, if the performance is your major concerns.

    Tuesday, March 8, 2016 7:31 PM
  • In the excel and web ui, user can use Filter to filter a subset of rows to work on.
    Thursday, March 10, 2016 1:43 AM

All replies

  • http://social.technet.microsoft.com/wiki/contents/articles/7812.master-data-services-capacity-guidelines.aspx

    The current MDS release 2012/2014, would support up to 10 million members per entity.

    In the SQL Server 2016, we significantly improve on performance and capacity. The new capacity guideline haven't been released yet.

    But in either version, MDS should handle the 1m gracefully.

    However, besides the size of the model, the specific user scenario/pattern also matter. You may want to build a prototype or proof of concept to test whether it works.

    I highly recommend to try SQL Server 2016 RC1, if the performance is your major concerns.

    Tuesday, March 8, 2016 7:31 PM
  • http://social.technet.microsoft.com/wiki/contents/articles/7812.master-data-services-capacity-guidelines.aspx

    The current MDS release 2012/2014, would support up to 10 million members per entity.

    In the SQL Server 2016, we significantly improve on performance and capacity. The new capacity guideline haven't been released yet.

    But in either version, MDS should handle the 1m gracefully.

    However, besides the size of the model, the specific user scenario/pattern also matter. You may want to build a prototype or proof of concept to test whether it works.

    I highly recommend to try SQL Server 2016 RC1, if the performance is your major concerns.

    Considering amounts of rows > 1 mil, is there another way of working with data for regular users besides Web UI or Excel add-in?

    Web UI does not support bulk changes and Excel can only work with 1,048,576 rows on single page.

    Wednesday, March 9, 2016 4:12 PM
  • In the excel and web ui, user can use Filter to filter a subset of rows to work on.
    Thursday, March 10, 2016 1:43 AM
  • Profisee has customers in production with up to 500 million records using MDS 2014 with Master Data Maestro.


    Val Lovicz
    http://www.profisee.com
    val.lovicz@profisee.com
    As the original creators of Microsoft MDS, Profisee's Master Data Maestro provides a range of enterprise-grade functionality to ensure MDS project success.

    Friday, March 18, 2016 9:36 PM