August 6, 2008 at 11:47 am
Hi guys how necessary is to do a job to clean spcache? what about flushdns ?
August 6, 2008 at 11:54 am
I don't know about flushing dns, but you should never need to flush the procedure cache on a SQL SERver. If you do that every query will need to re-cache a plan the next time it is executed. If you need a query or sp to re-compile just run it once with the RECOMPILE option.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 6, 2008 at 11:58 am
If you are testing/benchmarking, you can DBCC FREEPROCACHE, but it will slow down a production server as all plans have to be rebuilt then.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply