想让sql server 重用,必须参数化,即使拼接语句放在SP里,还是要重新编译
dbcc freeproccache
select sql,refcounts ,usecounts , * from sys.syscacheobjects order by bucketid
DBCC MEMORYSTATUS
select
* from sys.dm_os_memory_clerks
order by type
想让sql server 重用,必须参数化,即使拼接语句放在SP里,还是要重新编译
dbcc freeproccache
select sql,refcounts ,usecounts , * from sys.syscacheobjects order by bucketid
DBCC MEMORYSTATUS
select
* from sys.dm_os_memory_clerks
order by type