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>