Remove Procedure Cache and Reset Wait Stats

Remove Procedure Cache and Reset Wait Stats

Remove all elements from the plan cache for the entire sql server instance

Flush the cache and suppress the regular completion message

Remove all elements from the plan cache for a specific database

Remove the specific plan from the cache using the plan handle

Reset wait and latch statistics

PLAN CACHE POLLUTION

While the plan cache generally is self-maintaining, poor application coding practices can cause the plan cache to become polluted with a large number of query plans that are unlikely to be reused.Query to extract the query plans which are used only once and options to remove them.
Query to find out the plans which are used only once and options to handle.This also indicates ad-hoc workload to the server

Leave a Reply

Your email address will not be published. Required fields are marked *

*