Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DBCC FREESYSTEMCACHE('SQL Plans');
- DBCC FREEPROCCACHE
- SELECT TOP 1 type, name, pages_kb FROM sys.dm_os_memory_clerks ORDER BY pages_kb desc
- type name pages_kb
- CACHESTORE_SQLCP SQL Plans 38321048
- SELECT COUNT(*) FROM sys.dm_exec_query_stats WITH (NOLOCK)
Add Comment
Please, Sign In to add comment