Q:

How to free up memory in a system that runs 24/7

So I have created this particular system which uploads data from local Disk to database, I just checked recently that it had consumed 667MB worth of memory (In a 1GB RAM computer) Is there anyway to somehow, clear the memory?  I use GC.Collect and Dispose in every end of every sub. 

A:

Check if your process doesn't have any memory leaks and check what is the max.  memory usage in steady stage. Maybe it won't go farther. 
Regulate size of data that you are loading and number of insert rows in bulk in case of rel.  db or number of docs in case of non.  rel.  db.