Out of Memory Problem in VB 6.0 Application.



Dear All,

I have developed an application which is memory hungry. All the information
are stored in the memory (Using Array of Structures) and also in the SQL
server database. All the process will be done in the arrays and the final
update will be done in the SQL server database and I take care that both of
them are in synch.

Now the problem is when I tested the application under load it is giving
"Out of Memory". I am having around 10 arrays in which each array has more
than 60000 entries.

The Machine configuration is

Xeon 3.0 Processor (Server Mother board) with 4 GB DDR RAM with Windows 2000
Server (OS) and SQL server 2000 installed.

The memory used by my application is around 267 MB and the memory used by
sql server is aroung 497 MB and the total memory used is around 900 MB
including all the other Windows processes. Other than this, no other process
are running in that machine.

Can anyone please guide me on why this error is coming even though I have
sufficient RAM (4 GB RAM) ?

--
Thanks and Regards,

Peri



.



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: 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)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... Manager nusance has been around, and yet they somehow could never find time ... counter Total Server Mmeory shows 18GB. ... due to how the large memory allocation APIs work. ... Swap files for SQL do not need to be more than about 2-4 GB ...
    (microsoft.public.sqlserver.clustering)