SQL 2005 Merge Agent Blocking in MSmerge_generation_partition_mappings

SQL 2005 Merge Agent Blocking in MSmerge_generation_partition_mappings Chris Skorlinski Microsoft SQL Server Escalation Services If you observe blocking in the SQL Server 2005 Merge Agent script out the “nc1MSmerge_generation_partition_mappings” index and verify the “INCLUDE (changecount)” option exists.  TO verify, generate the create index script by expanding the system tables in the published database.  Then expand…


Initial Merge Synchronization not using Bulk Insert

Initial Merge Synchronization not using Bulk Insert Chris Skorlinski Microsoft SQL Server Escalation Services Working with a customer to setup a large subscriber we noticed the Merge Agent was NOT doing a BULK INSERT, but instead was doing row-by-row insert.  This had significant overhead for the Merge Agent resulting in longer then expected initial/reinit synchronization…


Portfolios, Programs, and Projects

Note: This article is updated at Portfolios, Programs, and Projects. Execution excellence as a one-man band is one thing.  Execution excellence for a team or group is another. One of the best ways to improve execution excellence for a team or group is to map out the portfolio, programs, and projects. Having clarity on the…


Visualizing Roadmaps for Execution Excellence

Note: This article is updated at Visualize Your Workstreams with a Roadmap. One of the first things I do to get a handle on execution is to map out the work in flight in the form of a roadmap. When there are multiple teams shipping stuff, one of the best ways to improve coordination, collaboration,…


Distribution Agent unable to STREAM when replicating as TSQL

Distribution Agent unable to STREAM when replicating as TSQL Chris Skorlinski Microsoft SQL Server Escalation Services New for SQL 2008 is the ability for the Distribution Agent to push updates to the Subscriber using multiple connections.  This feature, called Subscription Streams, only works when replicating transactions as stored procedures and not TSQL statements. See: Enhancing…


User Stories for Cloud Enterprise Strategy

Note: This article is updated at Cloud User Stories for Business and IT Leaders. This is a collection of user stories for the cloud.  This collection is a simple way to share the most common scenarios that Enterprise Architects, business leaders, and IT leaders will be facing as they adopt cloud technologies. I decided to…


Merge agent failing with “Cannot insert duplicates rows into table “tablename”. Violation of PRIMARY KEY constraint” during initialization.

Merge agent failing with “Cannot insert duplicates rows into table “tablename”. Violation of PRIMARY KEY constraint” during initialization. Sateesh Yele Microsoft SQL Server Support Last week, I worked on replication case where the merge agent was failing with the above error message. Here is the merge agent verbose log with the error message. Message: Batch…


Distribution agent failing with “procedure was called with an incorrect number of parameters”.

Distribution agent failing with “procedure was called with an incorrect number of parameters”. Sateesh Yele Microsoft SQL Server Support Transactional replication allows you to specify how data changes are propagated from the Publisher to Subscribers. For more information, please check this link. Specifying How Changes Are Propagated for Transactional Articles Recently, I worked on a…


Very Slow Data Repartitioning in SQL Server Replication with Precomputed Partitions

Very Slow Data Repartitioning in SQL Server Replication with Precomputed Partitions Chris Skorlinski Microsoft SQL Server Escalation Services Here is a great posting by Kevin Locke on a problem he encountered when data modifications occurred near the top of a complicated replication filter configuration.  These changes can cause “partition change” which triggers re-evaluation of all…


MSSQL_REPL-2147199360 Unable to decide if MakeGeneration is needed.

MSSQL_REPL-2147199360 Unable to decide if MakeGeneration is needed. Chris Skorlinski Microsoft SQL Server Escalation Services Error messages: Unable to decide if MakeGeneration is needed. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199360) Get help: http://help/MSSQL_REPL-2147199360 Query timeout expired (Source: MSSQLServer, Error number: 0) Get help: http://help/0 The merge process failed to execute a query because the query timed…