This morning I posted my first blog post on the SharePoint Escalation Team MSDN blog.
This explains the reason behind SQL Server’s query compile timeout error and how SharePoint can cause it to happen. I include some DMV queries that you can use to see if you are at risk for hitting this error.
If you have further questions about this problem, please contact me at firstname.lastname@example.org and I will advise you on the best course of action. You’ll likely need to open a support case if your question involves deep troubleshooting.