I am facing the same issue as mentioned above. When my engineer is reconfiguring drive for optimization Hard Disk Number changed and thus causing generating .snap files.

Can any one...

Adding to above Notes:

We decided to go with our own microsoft license and installed SQL on AWS. I see that services cannot be brought up immediately due to resource constraint....

This is not a stupid question. I faced it and until we know how this works it is annoying.

Please post the Execution plans before and after. I have faced similar situation recently and had created a process to save the execution plans which would come in handy in...