Explicit query plan pinning helps a lot, alongside strong profiling and monitoring tools.