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.
on:
UI for Editing Small Lakehouse Tables (Metadata & ...
on:
Power Automate visual in Power BI Desktop does not...
frithjof_v
on:
Job scheduler API: List failed runs