Hello Friends,
In our project we have One SQL Job which run on pre-production & Production environment, For Pre-Prod it takes 7 hours to complete it and Production it will complete in 52 Mins.
We validated the SQL plan and found the Same Index for both environment as well as resource of Pre-prod is slightly lower as compared to Prod.
Could you please consult what need to further check on Pre-prod environment to match execution time of SQL Job.
Thanks in Advance 😊
Daily basis We run the gather stats on underlying tables.
How frequently do you gather stats on the underlying tables on both prod and pre-prod?