VB - SQL Server memory problem
Posted on 2000-05-08
we have several servers with sql server 7 and identical databases on each.
so far 2 of them have been using more and more memory i.e. initially about 100000K and increasing steadily over several days or weeks to over 1000000K.
we have several VB programs running on the severs. one of them is continually polling a table in the database - checking to see if there are any new records and if there is they are processed and deleted.
we are using RDO to access the database
and the recordsetset is never closed i.e. it is reset every time we poll the table. the timer controlling this has an interval of 1 millisecond.
after processing the records are transmitted to other computers using a tcp control - i dont know which.
also CPU usage steadily increases even though there is very little activity.
eventually the computer comes to a halt and must be rebooted.
any ideas what is causing these problems