sqlserver缓存计划-扫除只使用一次的缓存计划

plan cache很大，将只使用一次的缓存计划清除，而不用清除整个cache.declare @sid varbinary(64)declare cur01 cursor forselect  plan_handle from (SELECT  plan_handle  FROM sys.dm_exec_cached_plans AS cp CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) stWHERE cp.cacheobjtype = N'Compiled Plan'AND cp.objtype IN (N'Adhoc', N'Prepared')AND cp.usecounts =1 and  text   like 'select%') copen cur01fetch next from cur01 into @sidwhile @@fetch_status=0beginDBCC FREEPROCCACHE(@sid)fetch next from cur01 into @sidendclose cur01deallocate cur01go