SQL Server 2005：清空plan cache
DBCC FREEPROCCACHE
This command removes all of the cached query plans and execution contexts from the plan cache. It is not advisable to run this command on a production server because it can adversely affect performance of running applications. This command is useful to control plan cache's contents when troubleshooting a recompilation issue.
DBCC FLUSHPROCINDB( db_id )
This command removes all of the cached plans from the plan cache for a particular database. It is not advisable to run this command on a production server because it can adversely affect performance of running applications.
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/37724/viewspace-998080/ ，如需转载，请注明出处，否则将追究法律责任。
