How do I clear the procedure cache?
dbcc freeproccache (undocumented) - Removes all elements from the procedure cache.
dbcc dropcleanbuffers - removes all the clean buffers from the buffer pool.
You can also stop and start SQL Server to achieve the same results.
I wanted to know how often one should do this and how you can tell something is wrong. Please provide me with some basic details.