Grant

Thanks for all your help i know at least have a better understanding of how to drill down using sql monitor.

I have traced the problem to some sharepoint reports that the datawarehouse guys start to run -

We might have to add more memory for this server as it only has 24gb (it alls in the cloud and quite cost wise shouldnt expensive !) and hopefully this will help

Once again thanks for your time.

Steven