Query sys.syscacheobjects : sys.syscacheobjects « System Tables Views « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Tables Views
3. sys.syscacheobjects

4> SELECT top 10 cacheobjtype, objtype, usecounts, sql
5> FROM sys.syscacheobjects
6> WHERE sql NOT LIKE '%cache%'
7>   AND sql NOT LIKE '%sys.%'
8>   AND sql NOT LIKE '%sp_executesql%';
9>
10> GO