Okay, I know this has been an absolute pain in the butt to deal with over these past few months. The SQL and DB has been changed now to a different version which is heaps quicker at responding.

I can see over the past couple of days since being back up everything seems to be running smooth and fast. Fingers crossed.