Steve Jones

Thanks for your response

You said "They didn't have a good way to fix it other than flush or restart the server" That is part of my problem once the SP slows down I can not do what you suggest because my site is hosted so I do not have authorization to flush or restart. This is actually the second time this has happened. The first time the hosting service restarted the server fixing the problem. I reworked all my SP to try and improve them. Everything worked fine for about 5 months then the SP's slowed down again.

I've tried:

- Dropping Tables, Stored Procedures, Indexes

- Updating statistics

- Reworking SP's

- Forcing SP recompile with (sp_recompile and WITH RECOMPILE)

The Only thing that worked once was for the Hosting service to restart the server and I don't think they will do that again. How can I force all of my cache to clean out so I can start the cache process from scratch ?

Thanks in advance