Thread: Intra-query parallelism ?????
02-14-03, 11:09 #1Registered User
- Join Date
- Nov 2002
Unanswered: Intra-query parallelism ?????
Iím using SQL 7.0 with FrontPage sending code to the dB.
Iím getting the following error and donít understand what it means.
Database Results Error
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Intra-query parallelism caused your server command (process ID #13) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers
The code is long and has several sub-queries.
All are looking to the same rows in the dB.
Iím passing a parameter from FP. If I remove the parameter and hardcode the value I donít get this error.
Is this problem SQL or FP? If SQL what am I looking at?
Thanks for you help
02-19-03, 01:40 #2Registered User
- Join Date
- May 2002
Re: Intra-query parallelism ?????
This does happen if you're on a multi-processor server. The query is being splitted up for parallel processing. Unfortunately, they happen to block each other.
As the error suggests, you either rerun or use option hint (maxdop 1) to limit the processing to one processor.--