excessive memory usage with dsc 8.2

[Kenny_K]

I am working on a program that is using LV 8.20 and DSC 8.2.  I have noticed that the sqlservr.exe will have almost 512 mb of memory usage after a couple of days.  This is seriously bogging down the computer and will eventually crash the computer, although it has not happened yet.  This program is supposed to run for months without a reboot.

I read some other threads and have disabled Alarm logging.  I am using less than 20 shared variables, acquireing data from a Fieldpoint uinit.  My deadbands are at 2% and can't really get any bigger. 

The cpu usage is almost nothing.  I am running the vi in the dev environment for the moment, it will eventually be moved to its own executable.

I currently have the data as being availible forever in the database settings.  I have been running the program off and on for the last month or so, usually for a couple days at a time and the database is on;y 4.5 mb so far, so the database is not getting large quickly.

Thanks

[Kenny_K]

I was able to solve my problem after some digging.  Apparently sqlservr.exe will allocate as much memory as it can in order to make any searching faster.  If naother program requests memory it will give it up, but it hogs as much of it as it can, which really slowed down my machine after a couple of days, even with 2 gb of ram.

At this link,

I found information on how to set a max limit on the memory, by default it is unlimited.  When you go to login, the thread says to enter "

C:\>osql -U sa -P yoursapassword".  By default, the password is blank, so dont enter anything for "yoursapassword".

After I changed my max memory, I immediatly saw the ram usage go down and my computer speed up.

[Ben]

Thank you Kenny!

Ben