Microsoft Diagnose SQL Server Compact 3.5 application performance issues and memory issues

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 run SQL Server Compact 3.5 applications on a Windows Mobile device or on a Windows CE device, they may encounter performance issues and low memory issues. This Advisory Services scenario assists customers who are seeking consulting assistance in diagnosing these issues.Customers need assistance to increase performance of a SQL Server Compact 3.5 application or a query, or need assistance to reduce memory usage at run time.

This may involve a code review, application profiling, Windows Mobile tools for virtual memory tracking and also SQL Server Compact 3.5, SQL Server or Visual Studio tools for query analysis.

Scoping questions

Included with scope

• Code review of limited scope in a Windows Mobile application

Part of this advisory may involve Wındows Mobıle and Compact Framework support engagement.

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.

SqlCeCommand objects are not automatically disposed if you use a SqlCeDataAdapter object (http://support.microsoft.com/default.aspx?scid=kb;EN-US;824462)

Methods to dispose of SQL Server CE, SQL Server 2005 Compact Edition, or SQL Server 2005 Mobile Edition managed objects from memory (http://support.microsoft.com/default.aspx?scid=kb;EN-US;834279)

Tips on SQL Compact Query Performance

• Go through the tips mentioned in Query Performance Tuning (SQL Server Compact) (http://msdn.microsoft.com/en-us/library/ms172984.aspx)  for SQL Compact query optimizations.
• You may also try generating the Query Execution Plan for SQL Compact in SSMS (http://technet.microsoft.com/en-us/library/bb896154.aspx) .

SQL Server Compact Garbage Collection – Whys and Hows (http://blogs.msdn.com/sqlservercompact/archive/2009/05/05/sql-server-compact-garbage-collection-whys-and-hows.aspx)

Windows CE .NET Advanced Memory Management  (http://msdn.microsoft.com/en-us/library/ms836325.aspx )

Windows Mobile 6.1 Memory Management Changes (http://bolingconsulting.com/blog/?p=4)

Slaying the Virtual Memory Monster (http://blogs.msdn.com/hegenderfer/archive/2007/08/31/slaying-the-virtual-memory-monster.aspx)

Slaying the Virtual Memory Monster - Part II (http://blogs.msdn.com/hegenderfer/archive/2007/10/01/slaying-the-virtual-memory-monster-part-ii.aspx)

"NETCF: Memory leak... now what??...SqlCeException: Not enough memory to complete this operation" (http://blogs.msdn.com/raffael/archive/2008/02/21/netcf-memory-leak-now-what.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.