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 - 2002-11-26 : 08:12:01
|
| sqldud writes "Hi SQL Team:I have 2 SQL 7.0 w/ SP4 running on NT 4 w/ SP6 with quad processors and 2GB of RAM running on DELL PowerEdge Servers. We run alot of DTS jobs to import data nightly. However, I can not figure out why these jobs hang/fail when SQL Server configuration "Parallelism" is configured as a default to use all of them. The "Parallelism" configuration have to set to 1 for these jobs to run w/o failing. Can you tell me what can cause this and where I can start troubleshooting the problems?Thanks" |
|
|
|
|
|
parallelism