Re: Used memory is smaller by ActiveSync?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 09:48:30 -0700

It's not clear if you are doing the same operations on both devices. SQL
Server CE, along with .NET CF will use memory based on what operations have
been executed. If you are syncronizing the database, then the SQL Server CE
cache is growing in size to hold the temporary transaction database. If you
close down the application and restart, you should see the memory be
returned to the memory pool immediately. Also, SQL CE will release the
memory over time.

"Khanh" <khanh@glassegg.com> wrote in message
news:b76c32be.0410210645.18f17e9d@posting.google.com...
> hi all,
>
> There is a weird phenomenon that i can't understand why.
> My PDA, PocketPC 2003, SQL Server CE, synchronizes master data with
> SQL Server 2000 by Merge Replication, and the local database file .sdf
> is about 70 MBs. In memory, I saw:
> Memory for program:
> Used memory: 77MBs
>
> Then I copied this sdf file to Desktop PC via ActiveSync, then
> copied to other PDA. The used memory size is smaller significantly!!!!
> Memory for program:
> Used memory: 45MBs
>
> File size is still the same on both PDA: 70 MBs, but used memories
> are various !!!!
> FYI, PDA is Fujitsu Loox FLX3AW, PocketPC 2003, Japanese version OS
>
> I would really like to know why. This can help my program having
> much free memory to run.
>
> Thanks,
> K

Relevant Pages

  • Re: Performance problems -- need guidance on scaling
    ... Thanks for the update on the FT Catalog corruption, ... will use, up to a max of 512Mb, if this memory is available. ... a server with 512 MB of RAM and a resource_usage value of 5 ... the data, you could, detach your SQL 2000 mdf & ldf files ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Memory Issues
    ... Exchange and SQL Server. ... you identified memory problems and large amounts of paging. ...
    (microsoft.public.sqlserver.setup)
  • Re: Performance difference between SQL Server 2005 and 2008
    ... Yes if the data pages are all in memory then there will be no physical I/O in this case. ... Andrew J. Kelly SQL MVP ... stored procedures run slower on new server. ... In order to make comparison more accurate, I picked query ...
    (microsoft.public.sqlserver.programming)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 Clust
    ... The Paging File usage is due to how the large memory allocation APIs work. ... Swap files for SQL do not need to be more than about 2-4 GB regardless of physical memory on the box. ... If you use Performance Monitor to track actual paging activity, you will see very little on a properly tuned SQL Server. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Allocating more memory to sql server
    ... Are you sure you have Windows 2000 Advanced Server and not just Server? ... SQL Server. ... memory used by SQL Server that will give a better idea of the actual usage. ... You also need to restart SQL Server after enabling AWE for it to take ...
    (microsoft.public.sqlserver.setup)