We noticed a large published database was taking a long time for the Snapshot to be applied to the subscriber. Looking further in sp_who and sys.sysprocesses we noticed only one Distribution Agent thread executing the bulk insert statements. It took a while but we discovered the publication was created using “concurrent snapshot” option. -MaxBcpThreads number_of_threads
Read More »
Sateesh Yele | Microsoft SQL Server Support Below is a list of self-help resources or this scenario. These resources are used by Microsoft SQL Replication Support Engineers during an Advisory Services engagement or while troubleshooting Web Synchronization problems. We hope you too find these helpful. Web Synchronization for Merge Replication http://msdn.microsoft.com/en-us/library/ms151763.aspx Topologies for
Read More »
I’m developing in-depth training on Change Data Capture and created this BLOG posting as a reference for BOL topics and Web links I found helpful while researching CDC. I’ll update this posting with more links as time goes by. I hope you too find these helpful. Basics of Change Data Capture (great chart and overview
Read More »
Back in 2010 I hosted a SQL DBA best practices discussion during the Charlotte SQL Server Users Group meeting. I’ve attached a couple of slides used during the discussion. If you ignore the “Will you upgrade to 64bit?”, its interesting to see much of the content still applies today. Welcome-to-Camp-GeekaLot-for-SQLDBA Enjoy.