Best practice question about troubleshooting

This is the answer I wish I had found six months ago. Would have saved me a weekend of trial and error.

Following this thread closely. We are about to face the exact same decision and the replies here are gold.