DBCC CACHESTATS
displays information about the objects currently in the buffer cache, such as hit rates, compiled objects and plans, etc.
DBCC FREEPROCCACHE
This command removes all cached plans from memory
DBCC FLUSHPROCINDB (dbid)
This command allows you to specify a particular database id, and then clears all plans from that particular database. Note that the usecount query that we'll use in this section does not return database id information, but the sys.dm_exec_sql_text TVF has that information available, so dbid could be added to the usecount query.
No comments:
Post a Comment