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
OneLake Catalog full-text and content search
Why is it not possible to search OneLake by item description or even content? So I was thinking about how a user can find a table if they don't know in which lakehouse it is located? Why can't you se...TePe8 hours agoHelper IVPlanned1.1KViews21likes5Comments