With regards to the error "Error converting data type nvarchar to bigint. [SQLSTATE 42000] (Error 8114). The step failed." I cannot really help without more info, but I think I...

Hello!

I'm going to take a look at these issues shortly and will get back to you.

Thanks for the responses. I'm using version 4 of SQL Monitor so can see the top waits: PAGEIOLATCH_SH and PAGEIOLATCH_EX are in the top 10, however all the other waits...

Thanks for the speedy response. I didn't think it would help (felt more like the devs washing their hands of the issue), but your point about BCHR being useless interested...