I have a small (~90MB) database that my production is recorded on and every 5 minutes this info is put into a txt file and sent via FTP to another offsite Server. Then the record that have been sent get flagged. The last couple of days my server timesout on the update and after trying the update a few time the whole DB becomes unresponsive and my production doesn't get recorded (leading more problems). My solution that last 2 days has been to reboot the server and try the update in a few hours.
What could be causing this and what should I do?
What could be causing this and what should I do?