there is a limit on amount of memory a single process can consume on the box, we dont want to increase that limit to 1.7gb yet, we think there is a problem with the way sql statment has been writen,