It seems that problems went away when i used ODBC to do the task, the normal load with sql server running is of about 150MB, and when the program inserted the registers via ODBC the load went up to 230MB, which is still not good, but it is far more acceptable than 650MB.