• Thank you for your reply.

    The server has currently got 4Gb RAM, I have tried setting the memory to fixed starting with 0 min to 1536 max. Reason for 1536 is because it is running standard edition and I read it somewhere that it can only access up to 2Gb of RAM, plus the fact that the server hangs at 1.7Gb of memory usage (Task Manager - Processes). But that didn't make any difference. The server is a dedicated for SQL used, only apps like virus checker, powerchute and other essential services running on it.

    Any other ideas?

    TIA

    Ken