Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-16 : 09:32:21
|
Lewis writes "
We are using SQL Server 7 with SP2. Recently I was given responsibility to find out why a certain SQL Select statment appeared to hang when similar queries ran OK.
It turned out that the non-working query was generating a parallel query plan. If I ran the query with the OPTION (MAXDOP = 1). It ran in a few seconds. (Note, it is a rather complex query that can return several thousand rows.
Anyway, since we had been experiencing other problems related to parallel queries (see Technet article #: Q240853) I configured all our production servers to have a Max Degree of Parallelism = 1.
Now, all the remote sites are reporting that their reports are running soooo much faster.
It seems counterintuitive that reports are running faster with serial queries.
We are running DELL 4400 with dual 700MHz processes with 1GB memory.
The base tables used by the reports were designed by a previous group of developers. They are poorly index and some are not even in 1NF. My fellow DBAs and I believe the cause of the problem is the database design and the indexes. The CTO is claiming that it is a MS Bug.
Anyone have any experience with a similar situation.
Thanks in advance,
Lewis DiFelice" |
|
|
|
|
|
Parallel Queries