RSA Scripts

Look for plans getting recompiled

Look to see if plans are getting recompiled due to memory issues.

  1. Sql Server
  2. Performance
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

-- Look to see if plans are getting recompiled due to memory issues
SELECT *
FROM sys.dm_exec_query_optimizer_info
WHERE counter = 'optimizations' OR counter = 'elapsed time'
GO