Merge Replication Capacity Planning

  Merge Replication Capacity Planning Chris Skorlinski Microsoft SQL Server Escalation Services I was recently asked for recommendations for Merge Replication capacity planning project.  While I spend most of my time tuning and troubleshooting Replication environments, I decided to post some thoughts on about stress testing and capacity planning.  I hope this posting helps as…


Key Questions for a PM at patterns & practices

Note: This article is updated at Program Manager Abilities at a Glance. I was looking for some of my old job descriptions for PM positions in patterns & practices to help out a colleague.  While I didn’t find them, I did find some of the questions that I have used to evaluate PM effectiveness: Project…


Replication Data Collection Scripts

Replication Data Collection Scripts Chris Skorlinski Microsoft SQL Server Escalation Services 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. …


Improve Snapshot Performance by changing MaxBcpThreads

  posted by: Chris Skorlinski, Microsoft SQL Server Escalation Services 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…


SQLServerAgent is not currently running so it cannot be notified of this action.

  SQLServerAgent is not currently running so it cannot be notified of this action. Chris Skorlinski Microsoft SQL Server Escalation Services Have you seen errors like these below when attempting to run SQL Replication Wizard or start a SQL Agent job?  TITLE: Microsoft SQL Server Management Studio —————————— SQLServerAgent is not currently running so it…


CDC does not require Unique Index

Unique Index not required for Change Data Capture Chris Skorlinski Microsoft SQL Server Escalation Services 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…


Snapshot Agent Performance –MaxBCPThreads

Snapshot Agent Performance –MaxBCPThreads 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…


All About Automatically Monitoring Replication Agent Failures

All About Automatically Monitoring Replication Agent Failures Vijay RodriguesMicrosoft 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…


Download the C# 4.0 Language Specification

Time to update your knowledge of the C# language! 🙂Get your copy of the C# 4.0 Language Specification here or of the C# 5.0 Language Specification here.

4

Trends for 2010

Note:  This article is updated at Trends for 2010. “The best way to predict the future is to create it.” – Peter Drucker This is my summary of key trends to watch for 2010.  Putting it together is a time-consuming exercise, but it’s one of the most important things I do for the year.  It…