Posted by wizofaus on 01/11/07 21:27

swaroop.a...@gmail.com wrote:
> be EXTREMELY wary when using DBCC DROPCLEANBUFFERS and DBCC
> FREEPROCCACHE on a production machine. They clear all cached SPs,
> queries and plans. The instance is bound to run under extreme stress
> for a considerable amount of time.
>
The instance? You mean it affects all databases?
In this case, I determined I'd have to do it before every single query
call, so obviously that's not practical.

[Back to original message]