The 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 collection scripts.
Read More »
content 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 an 80gig
Read More »
Change Data Capture feature of SQL 2008 is based on Transactional Replication. CDC and Transactional Replication used the same internal stored procedure sp_replcmds to retrieve data updates from the transaction log. However, unlike Transactional Replication, CDC does NOT require the tables to have a unique index (or Primary Key). In fact CDC can be use
Read More »
Vijay Rodrigues | Microsoft SQL Server Support SQL Server Management Studio provides a way to monitor events, such as replication agent events, using alerts. SQL Server includes a set of predefined alerts for replication agents. If you would like to start the monitoring for replication agent failures, please follow below steps. The below is configured
Read More »
Windows Synchronization Manager on x64 SQL 2005 BOL topics describe how to launch the Windows Synchronization Manager to synchronize a subscriber. How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager) http://msdn.microsoft.com/en-us/library/ms151863.aspx On x64 system, the BOL steps will start the x64 Win Sync Manager not the 32bit version. The x64 bit will
Read More »