Replication: Watch out for STREAM_BLOB_COLUMNS when setting up replication on your SQL 2008 + server

When setting up merge replication on your SQL 2008 + server, please be careful with the parameter STREAM_BLOB_COLUMN. By default, this option is set to FALSE, as explained here in BOL:  [ @stream_blob_columns= ] ‘stream_blob_columns’Specifies that a data stream optimization be used when replicating binary large object columns. stream_blob_columns is nvarchar(5), with a default of…

0

Replication: Merge Performance Tip

Problem: Publisher: SQL Server 2008 Subscriber: SQL Server Compact 3.5 Merge Replication Performance issue when using keep_partition_changes or precomputed partitions   Cause:   There could be many causes to this and analysis would have to be done however sometimes it may be due to missing indexes.   Solution/Workaround:   In a test environment, use the following…

0

Note to all Readers

Seems like there was an issue with the comments for this blog – I wasn’t getting notified and hence never got to respond. My apologies to all those that commented and never got a reply. If you do have a comment, please do not hesitate to e-mail me by selecting “e-mail Blog Author” Thanks!  

0

Replication: My merge agent keeps “dropping and creating” my newly added articles!!!

Problem: Consider the following scenario: You add a new article(s) to an existing publication in your merge replication environment and Your merge agent uses ‘-ParallelUploadDownload’ parameter with a value of 1 for synchronization. Note: Merge Agent profile High Volume Server-to-Server Profile enables parameter -ParallelUploadDownload In this scenario, you will notice that the merge agent enumerates…

0

Replication: Transactional Replication Over WAN

A lot of users have wondered about the performance latency transactional replication suffers over WAN. After analyzing / discussing this within the teams, here are the main points one should take into consideration when deciding / testing this type of implementation: Should you notice performance degradation when testing your transactional replication over WAN, please verify…

1

Replication: Merge Filters – optimize optimize optimize

I noticed that many people overlook optimizing their filters in a merge replication topology. This is crucial to performance and attempting to tweak the replication itself (example: using pre-computed partitions) may not be sufficient. An example of such: All the join filters specified against the published articles in merge publication would be evaluated during DML…

0

Replication: Infinite Retention Period Causing Performance Issues

A little explanation before explaining how to resolve this issue: The retention period for subscriptions specified for each publication controls how often the Publisher and Subscribers should synchronize. If subscriptions do not synchronize with the Publisher within the retention period, they are marked as ‘expired’ and will need to be reinitialized. This is to prevent…

1

SQL Server Performance Analysis Part V

PART V: “How To” get down to whatever is bringing SQL to its knees… At this point, following the previous Performance Analysis posts, we have arrived to the following conclusions: 1. We know what server / SQL Server build we are dealing with 2. We have checked for all errors SQL Server could have generated…

1