Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 2283249 - Last Review: February 21, 2011 - Revision: 1.2
Synchronization performance issues of SQL Server Compact 3.5 merge replication
Microsoft Professional Advisory Services is a support option that provides short-term, proactive, consultative support beyond break-fix product maintenance needs. This includes working with the same technician for assistance with issues like product migration, code review, or new program development and is a remote, phone-based support option. This service is typically used for shorter engagements, and is designed for developers and IT professionals who do not require the traditional onsite consulting or sustained account management services that are available from other Microsoft support options.
For additional information on Microsoft Advisory Services, including on how to engage, refer to this Microsoft web page:
http://support.microsoft.com/gp/AdvisoryService
(http://support.microsoft.com/gp/AdvisoryService)
When customers implement SQL Server Compact 3.5 merge replication, they may encounter synchronization performance issues. Typically, these issues occur when subscribers are on Windows Mobile devices. This Advisory Services scenario assists customers who are seeking consulting assistance on these issues.
Customers need assistance on synchronization performance issues. Questions may involve the following things:
- hardware resources on the device (memory, CPU, storage card)
- application performance
- network bandwidth (GPRS, wireless, LAN)
- resources on IIS and SQL Server
- schema enhancements for SQL Server Compact 3.5 replication
- upgrade performance comparing to earlier versions
- logging and tracing at client, network and server
 Recommendations on version compatibility and application tuning for performance.
Scoping questions
Included with scope- Code review of limited scope in a Windows Mobile application.
Out of scope- Code review or custom code development of whole applications or classes in an application.
- Reverse engineering of Microsoft or third-party code in order to develop a custom solution.
- Code review of third-party code.
Below is a list of self-help resources or this scenario. These resources may also be used by Microsoft Support Engineers during an Advisory Services engagement.
Performance: Tips for faster download of a large SQL Compact 3.5 database via Replication
(http://blogs.msdn.com/b/sqlblog/archive/2009/06/24/performance-tips-for-faster-download-of-a-large-sql-compact-3-5-database-via-replication.aspx)
MEAP + Mobile Merge Replication Performance and Scalability Cheat Sheet
(http://robtiffany.com/sql-server-compact/meap-mobile-merge-replication-performance-and-scalability-cheat-sheet)
PostSyncCleanup to turn off UpdateStatistics during initial download of SQL Compact Replication
(http://blogs.msdn.com/b/sqlblog/archive/2009/04/15/sql-compact-performance-postsynccleanup-to-turn-off-updatestatistics-during-initial-download-of-sql-compact-replication.aspx)
FIX: An error message is logged, and the synchronization may take a long time to finish when you synchronize a merge replication that contains a SQL Server Compact 3.5 subscriber
(http://kbalertz.com/Feedback.aspx?kbNumber=963060)
ReplTalk Start Here
(http://blogs.msdn.com/b/repltalk/archive/2010/02/07/repltalk-start-here.aspx)
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.
APPLIES TO
- Microsoft SQL Server Compact 3.5
| kbproadvisory kbhowto kbinfo kbsurveynew kbexpertiseadvanced kbprosql KB2283249 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate