Most of our queries are generated by an ORM (object relational mapper). Three weeks ago we put two new sql cluster boxes into service with 512GB of memory. Yesterday a report-type query with a ton of joins and a union was run from the application and it created stack dumps showing error " too many parallel nested transactions." Without more coding, the developers say they can't use a max degree of parallelism option. The server is set at maxdop zero.
Sql 2005 Enterprise SP4 9.0.5000 64bit
SQL Server Assertion: File: <lckmgr.cpp>, line = 385 Failed Assertion = '0' Too many parallel nested transactions. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.