I have found that you often have to provide some hints to the LLM. Also, providing server logs from production can also greatly assist it in finding performance

I have found that you often have to provide some hints to the LLM. Also, providing server logs from production can also greatly assist it in finding performance issues. I have had pretty good success with this, and it has saved me a lot of time. Just be extremely scrutinizing about the solutions that it proposes, because those are frequently suboptimal.