On one of our production Sharepoint Sites we have a ListItem that will not load it's details. It simply times out and throws an exception with a GUID. The Log file indicates that:
System.Threading.ThreadAbortException: Thread was being aborted. 08/25/2011 13:14:04.03 w3wp.exe (0x1DB4) 0x1184 SharePoint Foundation General xxpm High Unable to execute query: Error 0x80131530 66c92e39-0443-40b0-bef8-d9d74e292fbd
I am asking for Read access to all databases on our Sharepoint server so that I can see how long the SQL command (shown in the logs) takes to execute. It's an absolute massive query.
How does one go about troubleshooting a Listitem that is having SQL Server timeouts?