To improve SQL Distribution agent performance when applying Snapshot, first ZIP then copy the snapshot files locally to the subscriber. This is a great solution for subscribers on WAN international networks as ZIP can be smaller and faster to copy then Replication can move uncompressed Snapshot files. Testing shows a 1gb file can take >
Read More »
My friend Brendan Odwyer gave me great query to show Distribution database breakout by article for Transactional Replication publications. We used this to identify 1 table that had +90 million rows pending in the Distribution database as result of a large bulk update. It would have taken Replication days to move that bulk down row-by-row.
Read More »
Content provided by Sateesh Yele, Microsoft SQL Escalation Services BOL/MSDN documents –Logscanthreshold as “internal use only”. https://technet.microsoft.com/en-us/library/ms146878(v=sql.110).aspx -LogScanThreshold scan_threshold Internal use only. Other blog postings imply how to adjust this setting for better Logreader agent performance. If you add this parameter to the Logreader SQL Agent command line and start the agent, Logreader agent will
Read More »
by Holger Linke, Microsoft SQL Escalation Engineer GUIDs and Clustered Indexes Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones. With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical. As you know, each row is
Read More »