Appliance Feature Switches
The Feature Switch page displays information about the feature switches that are being introduced in Analytics Platform System AU7 and later. Use this configuration page to update or enable/disable features and settings in Analytics Platform System.
Note
Changes to feature switch values require a service restart.
AutoStatsEnabled
Controls the auto statistics feature. This feature switch is set to true by default after upgrading to AU7. Any database created after the upgrade will inherit auto creation and asynchronous update of statistics. For existing databases, database administrators can enable auto statistics with ALTER DATABASE (Parallel Data Warehouse). For more information on statistics, see Statistics.
MaxDOPForInsertQueries
Allows you to pick maxdop settings greater than 1 for insert/select operations. Options for this setting are 0, 1, 2 and 4, with default being 1.
OptimizeCommonSubExpressions
Improves query performance by eliminating data movement for common subexpression in SQL query optimizer. Detailed explanation of this feature can be found here.
UseCatalogQueries
Using catalog objects for some metadata calls instead of using SMO has shown performance improvement. Set to true by default in CU7.1, this switch controls that behavior.
DmsProcessStopMessageTimeoutInSeconds
Controls the time Data Movement Service (DMS) waits to synchronize on a busy system when a query involving data movement is canceled. Updating to AU7 sets this value to 900 seconds (15 minutes) by default. The valid range is 0 - 3600 seconds.
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho