Stabilizing Azure SQL Database Queries With Query Store Plan Forcing
Parameter sniffing makes Azure SQL Database queries unstable across parameter values. Using Query Store to observe plan variance and plan forcing to lock a stable plan can provide deterministic performance without schema or code changes.
azuresqldatabase