Filtered Indexes and Forced Parameterization: Can’t we all just get along?

We have a database here that stores information about Azure SQLDB health issues; it was chugging along fine for months, then earlier this week it started to struggle. You can see the large increase in steady-state CPU consumption: After asking around, we learned that forced parameterization had been enabled on this database around the time…

0