Problem solve Get help with specific problems with your technologies, process and projects.

What impact does changing one record have on the database?

We are fine-tuning our banking system business application to reduce bandwidth use for online real-time transactions processing.

If we change one record in one table (under a merged replication scenario), do we push the whole database? Or do...

we push that one table with the change? Or only the changed record?

This change would be based on how the subscription is set up. Review the subscription settings to see which data is being replicated. The easiest means to do so is in Enterprise Manager. Reference the following article for additional tips: Merge Replication Performance Tuning and Optimization.
This was last published in December 2005

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.