SentryOne Team Blog (blogs.sentryone.com)

Tag: plan cache

Erin Stellato : Mining Plans : Not just for the plan cache

Erin Stellato : Mining Plans : Not just for the plan cache

Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database.

Aaron Bertrand : Different Plans for "Identical" Servers

Aaron Bertrand (@AaronBertrand) walks through several potential causes for different plans and/or performance for the same database on two "identical" servers.

Aaron Bertrand : Multiple Plans for an "Identical" Query

Aaron Bertrand (@AaronBertrand) discusses a handful of reasons "identical" queries might yield multiple plans, contributing to plan cache bloat.