--适用MSSQL2000、MSSQL2005
use master
declare @dbid int
Select @dbid = dbid from sysdatabases where name = 'Test'--修改成数据库的名称
select
dbid,UseCounts ,RefCounts,CacheObjtype,ObjType,
DB_Name(dbid) as DatabaseName,SQL
from syscacheobjects
where dbid=@dbid
order by dbid,useCounts desc,objtype
查看数据库缓存的SQL
最新推荐文章于 2022-07-30 22:44:36 发布