There is a bucket in plan cache with 75 objects in it and it is the same sql statement. Other than using DBCC FREEPROCCACHE what will clear out the cache? Restarting SQL SERVER Service? I use the code below to look up how many plans are in a bucket.
SELECT bucketid, entries_in_bucket = COUNT(*) FROM sys.dm_exec_cached_plans GROUP BY bucketid ORDER BY 2 DESC
SQL SERVER 2005
December 28, 2010 11:30 PM
December 29, 2010 1:59 PM