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

1. SQL Server / T-SQL
2. System
3. 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

 

Related examples in the same category