07. How to React to Parameter Sniffing Emergencies

Remember the things we discussed in the last module? Restarting the service, rebuilding indexes, updating stats, and freeing the entire plan cache? Yeah, don’t do that. You solve the parameter sniffing emergency for one query, but you cause a parameter sniffing emergency for the rest of ’em – because now all the other queries are suddenly getting…

Remember the things we discussed in the last module? Restarting the service, rebuilding indexes, updating stats, and freeing the entire plan cache? Yeah, don’t do that. You solve the parameter sniffing emergency for one query, but you cause a parameter sniffing emergency for the rest of ’em – because now all the other queries are suddenly getting...
Menu