Guest User

Untitled

a guest
Oct 18th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. DBCC FREESYSTEMCACHE('SQL Plans');
  2.  
  3. DBCC FREEPROCCACHE
  4.  
  5. SELECT TOP 1 type, name, pages_kb FROM sys.dm_os_memory_clerks ORDER BY pages_kb desc
  6.  
  7. type name pages_kb
  8. CACHESTORE_SQLCP SQL Plans 38321048
  9.  
  10. SELECT COUNT(*) FROM sys.dm_exec_query_stats WITH (NOLOCK)
Add Comment
Please, Sign In to add comment