Very slow merge replication between SQL Server 2008 R2 and SQLCE 3.5 PDA clients
Posted on 2012-09-02
I have a Merge Replication infrastructure consisting of two servers and various Windows Mobile clients all running SQLCE 3.5 SP2:
1. an application server running IIS and SQL Server Compact Server Tools (64bit), and
2. a database server running Microsoft SQL Server 2008 R2 Standard Edition
Both servers run Windows 2008 R2 Standard Edition (64bit).
The database that I need to replicate to the Windows Mobile clients is quite small, aroung 21 mb, however it consistently takes around 1.5 hours to complete a full data synchronization between a Windows Mobile client and the app server running IIS 7.5.
My previous environment (SQL 2000 on Windows 2003 and SQLCE 2.0) only took around 5-6 minutes to fully synchronize the database, so I am at a loss as to what is going on...
The only thing different from my previous environment is that I had ONE server running both IIS and SQL Server, whereas now I have two servers, one application server running IIS 7.5 and the SQL Compact Server Tools (64bit) and another database server running only Microsoft SQL Server 2008 R2 Standard Edition.
Can you please help find out what is going on?