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
Retain Matrix/Table Scroll Position When Returning from Drillthrough
Description: Currently, when users drill through from a Matrix or Table visual to a detailed page and then use the Back button to return, the report navigates back to the source page but resets the ...Pruthviraj151 hour agoNew MemberNew5Views0likes0CommentsRetain Matrix/Table Scroll Position When Returning from Drillthrough
Description: Currently, when users drill through from a Matrix or Table visual to a detailed page and then use the Back button to return, the report navigates back to the source page but resets the ...Pruthviraj1 hour agoNew MemberNew3Views0likes0CommentsExpose Data Agent schema, question interpretation, and generated query through MCP
I would like to request additional context and metadata capabilities for the Microsoft Fabric Data Agent MCP server. It would be very useful if the MCP server could expose more information about the...Antoine17332 hours agoRegular VisitorNew2Views0likes0CommentsReal-time progress streaming for Fabric Data Agent MCP server
I would like to request true real-time progress streaming for the Microsoft Fabric Data Agent MCP server. Currently, when calling a published Fabric Data Agent through MCP using call_tool with a pro...Antoine17332 hours agoRegular VisitorNew3Views0likes0Comments