Cache

Get-DbaPlanCache

Get-DbaPlanCache View Source Tracy Boggiano, databasesuperhero.com Windows, Linux, macOS Synopsis Retrieves single-use plan cache usage to identify memory waste from adhoc and prepared statements Description Analyzes the plan cache to identify memory consumed by single-use adhoc and prepared statements that are unlikely to be reused. These plans accumulate over time and can consume significant memory without providing performance benefits. When applications generate dynamic SQL without proper parameterization, each unique statement creates its own execution plan.