What is wrong with MDS (Master Data Services) Database in SQL Server 2019
Read OriginalThis article is a detailed technical analysis and critique of the Master Data Services (MDS) database in SQL Server 2019. The author, having contacted the product team repeatedly, lists problematic default configurations including an outdated database compatibility level (110/SQL Server 2012), the use of TORN_PAGE_DETECTION for page verification instead of CHECKSUM, lack of support for modern compression like Columnstore indexes, and unreasonable initial file size and growth settings. The goal is to raise awareness so these issues can be fixed before the final release.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser