Mega Code Archive
Categories
/
MSSQL
/
System
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