What is SQL Server plan cache pollution and how does it degrade performance?

Plan cache pollution occurs when too many single-use or suboptimal execution plans fill the cache.

SQL Server stores execution plans to improve reuse. However, ad-hoc queries with literal values generate many unique plans, consuming memory and evicting useful cached plans. This leads to increased compilation CPU cost and reduced cache efficiency. Forced parameterization or sp_executesql helps reduce pollution.