Its all good - I appreciate any advise you can give.

Anyway I sent you two procedures because I think our archiving process might be involved with causing the issues. Apparently it runs 24/7 so I spoke to the vendor about limiting its run time. I was concerned that the mirrored archive database was interfering with the day to day transactional stuff -but I'm not exactly sure if that is the issue because I would of expected something to show up with the blocked process report when I run it earlier.

So after discussions today with the vendor I have decided to remove mirroring from the archive database. It is a bit early to tell but it so far 1 have only got 1 query/stored proc in the last 8.5 hours that is running slow (over 5 seconds).

Anyway the procedures are attached

insertvehiclenotification.txt is the stored proc that contains those sql statement I originally sent.

movearchiverecordtotable.txt is the proc that move data out of the live table into the archive tables.

Let me know if I can help you/help me any other way:-)