Hi All,

I appreciate all the responses. Sorry for being slow in getting back to you.

Grant - The data is exactly the same. Each message is piped to both environments.

MadAdmin - I have attached the output of the 2 queries you have provided. As far as I can tell the indexes look the same. The default index fill factor is set at 0 for both environments at the server level. Also the isolation level is set to "read committed" in both databases.

Jeff - I like the suggestion and while it sounds logical unfortunately we are stuck with what we have. I did raise the issue with the vendor before trying this forum but I have been given no feedback whatsoever. Great vendor.....