0

We have a commonly utilized stored procedure that had been functioning properly, but it unexpectedly began utilizing several plans (as many as 20, according to the performance analyzer) and causing a lot of blocking. The wait activity associated with it was PAGEIOLATCH_SH. This lasted for an hour (at night when no one uses our application) before reverting to its typical plan usage during the day. What could have caused this alteration?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.