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…


Reducing Impact of Large Updates on Merge Replication

Reducing Impact of Large Updates on Merge Replication Chris Skorlinski Microsoft SQL Server Escalation Services One key parameter to consider when performing batch updates against tables enabled for Merge Replication is ‘generation_leveling_threshold’.  This setting controls how many data changes should be grouped into one generations (or batch).  The Merge Agent then collect and sends those…


Clearing Resolved Merge Replication Conflicts

Clearing Resolved Merge Replication Conflicts Chris Skorlinski Microsoft SQL Server Escalation Services Content provided by: Steve Dybing, Microsoft SQL Server Support Background on Merge Conflicts ———————————————- When a Publisher and a Subscriber are connected and synchronization occurs, the Merge Agent detects if there are any conflicts. If conflicts are detected, the Merge Agent uses a…


Impact on Log Reader Agent after reindex operations

Impact on Log Reader Agent after reindex operations José Moreira Neto Microsoft SQL Server Escalation Engineer Certain table reindex operations, like online reindex or reindex operation while database is running in full recovery model, will create large amounts of transaction log records in the database transaction logs. This may or may not generate an actual…


Oracle to SQL Server Replication

Oracle to SQL Server Replication Posted by Chris Skorlinski Microsoft SQL Server Escalation Services Content provided with help of Jonathan Clark, Microsoft SQL Server Escalation Services Oracle to SQL Server replication is used to support customers migrating Oracle legacy application to Microsoft SQL Server.  The data changes in Oracle can be replicated near real-time to…


Increased partition support of SQL Server in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Increased-partition-support-of-SQL-Server-in-SAP-BW/ba-p/367105 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html As of SQL Server 2005 you can partition table and indexes. The maximum number of partitions used to be 1,000 for SQL Server 2005, 2008 and 2008…


How to add an article to an existing Transactional Subscription initialized through backup

How to add an article to an existing Transactional Subscription initialized through backup Sakthivel Chidambaram Microsoft SQL Server Support There are situations where you initialize a Transactional subscription from a backup and later you need to add an article. If the publication was created using Snapshot Replication, you can re-run the Snapshot Agent and only…


When publishing the EXECUTION of a Stored Procedure wrap in Transaction

When publishing the EXECUTION of a Stored Procedure wrap in Transaction Chris Skorlinski Microsoft SQL Server Escalation Services When Replication the EXECUTION of a stored procedure to a subscriber select the “serialized transaction” and and wrap the SP execution within a transactions. This ensures the changes are replicated as a single stored procedure execution and…