SQL Server/T-SQL/System/sys.syscacheobjects
Query sys.syscacheobjects
<source lang="sql">
2> SELECT top 10 cacheobjtype, objtype, usecounts, sql 3> FROM sys.syscacheobjects 4> WHERE sql NOT LIKE "%cache%" 5> AND sql NOT LIKE "%sys.%"; 6> GO
</source>