大网数据广告活动
数据库与应用安全

Issues when modifying entities, attributes, users, or groups in MDS

· 52CE 我爱测

Provides the historical background and a resolution for performance issues that occur when modifying entities, attributes, users, or groups in Master Data Services.

This article helps you understand and solve performance issues in Master Data Services (MDS) when you create or modify entities, attributes, users, or groups.

Symptoms

When you add, remove, create, or modify entities, attributes, users, or groups, you experience performance issues like high memory usage, long load times, or slow response times.

Cause

MDS introduced a significant improvement that enhances the performance of all GET operations for data requiring permission checks through the portal and API (that is, all the entities, attributes, and model permissions). However, this change has a side effect: decreased performance when you add, remove, create, or modify entities, attributes, users, or groups.

  • Benefits (performance improvements):

    • Improved performance for loading pages that need permission checks, such as the explore page, model page, entity list page, and attribute list page.
    • Resolved time-out exceptions on the model permissions setting page.
    • Improved the load time of the add or edit condition page on the Business Rules page.
  • Costs (side effects):

    • Decreased performance when you create or modify entities or attributes.
    • Decreased performance when you add users or groups.

Resolution

Enable or disable the system setting PerformanceImprovementEnable (the setting is enabled by default) depending on your situation:

  • To improve performance when loading permission-related pages, enable the performance setting by running the following commands in SQL Server Management Studio (SSMS):

    UPDATE mdm.tblSystemSetting SET SettingValue = 1 WHERE SettingName = 'PerformanceImprovementEnable';
    EXEC [mdm].[udpPerformanceToggleSwitch];
    GO
    

    After you enable the performance setting, large user security-related data will load faster.

  • To improve performance when creating or modifying entities, attributes, users, or groups, disable the performance setting by running the following commands in SSMS:

    UPDATE mdm.tblSystemSetting SET SettingValue = 0 WHERE SettingName = 'PerformanceImprovementEnable';
    EXEC [mdm].[udpPerformanceToggleSwitch];
    GO
    

    After you disable the performance setting, creating and modifying models, entities, or attributes will be faster.

Note: Alternatively, you can change the setting on the Database Configuration page in MDS Configuration Manager:

:::image type="content" source="media/performance-improvement-mds/switch-enable-performance-setting.png" alt-text="Screenshot of the performance setting PerformanceImprovementEnable.":::

After changing this setting, you must run the EXEC [mdm].[udpPerformanceToggleSwitch]; command to make sure that the view and data are correct.

More information

Immediately apply member permissions (Master Data Services)

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 11/11/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。