Hi,
I totally agree - I am now at the last resort phase!
We simply cannot have a database which slows down after 3-10 days.
I have looked at the statistics, but i'm not sure what they are supposed to tell me. There are 2 large tables (10m rows) and the statistics reflect this on those tables.
However i'm not sure how statistics relate to a slowing down database which speeds up by freeing the proc cache?
Thanks
Simon