Wocketfast's IT blog

Tuesday, 10 May 2016

SQL server cached plans

If you are using OpenQuery or sp_execute_sql a lot then your server is probably loaded with cached execution plans, for adhoc queries that will never be used again.

These two grate blogs deal with the issue nicely
http://sqlmag.com/database-performance-tuning/sql-server-plan-cache-junk-drawer-your-queries 
http://www.sqlskills.com/blogs/kimberly/plan-cache-and-optimizing-for-adhoc-workloads/ 


Read more »
Posted by Wocketfast at 13:53 No comments:
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Blog Archive

  • ►  2019 (1)
    • ►  March (1)
  • ►  2018 (1)
    • ►  July (1)
  • ▼  2016 (2)
    • ►  June (1)
    • ▼  May (1)
      • SQL server cached plans
  • ►  2014 (5)
    • ►  November (1)
    • ►  October (1)
    • ►  January (3)
  • ►  2013 (1)
    • ►  November (1)
  • ►  2009 (1)
    • ►  January (1)
  • ►  2008 (2)
    • ►  May (2)
  • ►  2007 (6)
    • ►  November (3)
    • ►  July (3)

About Me

Wocketfast
View my complete profile
Simple theme. Powered by Blogger.