Share this PostThe Microsoft SQL Server Support team uses various scripts to collect Replication and Performance data from customer’s SQL Servers. These scripts extract data into either text files or into temporary databases which are then backed up and sent to Microsoft SQL Engineer for analysis. Below are links to some of these common data
Read More »
Share this Postcontent provided by: Akbar Farishta, Technical Lead, Microsoft SQL Server Support I wanted to post an update to Snapshot Agent Performance –MaxBCPThreads blog posting. We recently encounter a performance problem trying to push a 120gig snapshot down to a subscriber. The Distribution Agent was taking a long time doing a Bulk Insert on
Read More »
Share this PostWe 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.
Read More »
Share this PostWhen creating a Transactional Replication publication, what happens if I check Create a snapshot immediately and keep the snapshot available to initialize subscriptions? This sets the publication property @property=‘immediate_sync’,@value=‘TRUE’ which instructs Replication to keep all the transactions cached in the Distribution database for the entire Retention Period. Normally these rows are purged as
Read More »
Share this PostThe Microsoft Knowledge Base contains the following article for setting up a SQL 2000 Subscriber using Backup/Restore. Once the subscriber is restored sp_scriptpublicationcustomprocs is executed to create the subscriber Replication SPs. 320499 How to manually synchronize replication subscriptions by using backup or restore http://support.microsoft.com/default.aspx?scid=kb;EN-US;320499 These steps should be modified for SQL 2005/2008 which
Read More »