It's seems to be a network service that is running it from the server itself. I've installed ideara diagnotic manager recently but other than that no SP's, any batch...

cheers will drop the cache clearing.

Moved from SQL Express 2005 to SQL Standard 2008 and load of performance problem since. Wish I had of left it as is. ;-).

so don't bother rebuilding indexes, stats, free caches?

cheers already rebuilding indexes, stats, freeing caches etc once a day.

database is 3GB server has 4GB with 5 drives in raid 5 (client decision) again. Have asked for OS...

upgraded to sql server 2008 with 4 user cal (clients decision not mine) and since then we've been experiencing lots of session blocks.