While troubleshooting why a query failed on our SQL Server 2005 cluster, I note in the SQL Server log that SQL Server seems to have shutdown and restarted.
Looking at the System Event Viewer, I see that "Cluster resource 'SQL Server' in Resource Group 'Group 0' failed"
Prior to this, there are hundreds of entries about "There is insufficient memory to run this query."
How can I find out more? What can the root of the problem be?