SQL Server/T-SQL/System/sys.syscacheobjects

Query sys.syscacheobjects

 

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