Friday 19 November 2021

How to transfer a "good" execution plan from one DB to another?

 The article below is very good and useful, I was following the instructions and I was able to force the Production DB execution plan in ST DB, even that the problematic query never used the good plan in UAT.


https://docs.rackspace.com/blog/transfer-sql-plans-by-using-sql-plan-baseline/


Florin

No comments:

Post a Comment