I had increased query cost to 1200, there was no difference... Now, even the sql's (using except) are not running in backend.
So i have changed query governor setting to 0 and remote query timeout to 0 which seems to have solved teh problem...Am not sure if anyone has changed the query cost time,earlier...
Thanks..