Configurable Parameters for Optimizing Initial Snapshot in SQL Server Mirroring to Fabric
In SQL Server mirroring to Microsoft Fabric, there are currently no configuration options to control or optimize the initial snapshot (for example, adapting the current table to partitioning or adjusting the batch size for row transfers).
I propose adding configuration parameters that would allow the initial snapshot process to be more tunable and efficient (Example rows per batch, MAXDOP for the operation or similar to backup.. BUFFERCOUNT and control the number of buffers assigned to the operation etc etc).
While there are some documented options to improve ongoing mirroring performance itself (SQL Server mirroring performance in Fabric), nothing exists today for the initial snapshot. This becomes a significant challenge when dealing with very large tables, as it is difficult to optimize the process without such controls.
Recent ideas
Dynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db3 hours agoNew MemberNew236Views2likes2CommentsReintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...Sri-Surendra_Ku6 hours agoNew MemberNew106Views14likes1CommentSupport Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull227 hours agoAdvocate INew12Views1like0CommentsImprove Relationship UI Wording to Better Reflect Filter Propagation Direction
The current relationship dialog can be confusing because the UI labels "From" and "To" do not always align with users' linguistic expectations regarding filter propagation. As per document : Relation...v-varunvv8 hours agoMicrosoft EmployeeNew20Views4likes0Comments