SQL Server 2005：清空plan cache

最新推荐文章于 2024-07-03 20:48:22 发布

转载最新推荐文章于 2024-07-03 20:48:22 发布 · 84 阅读

本文介绍了两个SQL命令：DBCC FREEPROCCACHE用于清除所有查询计划缓存；DBCC FLUSHPROCINDB用于清除特定数据库内的计划缓存。这两个命令在生产环境中需谨慎使用，以免影响应用程序性能。

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博客 ” ，链接：http://blog.itpub.net/37724/viewspace-998080/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/37724/viewspace-998080/