Sample Header Ad - 728x90

Force Microsoft SQL to recreate and use Specific execution plan?

0 votes
0 answers
833 views
I have a stored procedure that was working really well for about 3 weeks, than all of a sudden it basically ground to a complete Stop. This was i believe due to the server creating an additional query plan that was far less efficient. good plan bad plan For whatever reason both of these plans were flushed from the server. Is there a way to get the Server to recreate the good plan ? i have a copy of the plan (the graphical format), the query hash and the plan hash but wasn't sure if the plan hash still exists anywhere after being flushed. "Good" Plan: https://www.brentozar.com/pastetheplan/?id=S1TLgATDo "Bad" Plan: https://www.brentozar.com/pastetheplan/?id=Hy5cJATwi
Asked by Praxiom (101 rep)
Dec 7, 2022, 07:55 AM
Last activity: Dec 7, 2022, 11:20 AM