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 |
|
Nigel Keith-Walker
Starting Member
3 Posts |
 Posted - 2006-05-24 : 01:10:44
|
| Why does the SQL Server Enterprise Manager seem to block other processes? I am working with SQL2000 developers version with SP4. When I set up a Data transformation service, it is not actioned until I close/open the Server Enterprise Manager. Otherwise it sits there as Process id 51 Master - runnable (this is the SEM) and Process id 52 - DTS sleeping.Nigel Phact |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-24 : 01:34:59
|
| it's not the enterprise manager, look at the task being done and see if there is indeed blocking...you might be getting cpu peaks which is why if you close EM, the other tasks can continueHTH--------------------keeping it simple... |
 |
|
|
Nigel Keith-Walker
Starting Member
3 Posts |
Posted - 2006-05-24 : 03:05:40
|
| It occurred on several occassions. It was not just a delay, because I walked away and returned hours later. I accept that it is not SEM. Could anyone suggest the reason why a DTS, set to immediate might be delayed.Nigel Phact |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-24 : 03:54:25
|
| What is the DTS package trying to do?-------Moo. :) |
|
|
|
Nigel Keith-Walker
Starting Member
3 Posts |
Posted - 2006-05-24 : 08:45:25
|
| The DTS packge is creating tables in a new database based upon tables in Access 2003. Do you think that some security is blocking the DTS?Nigel Phact |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-24 : 09:29:59
|
| Unlikely. That would just generate an error message.-------Moo. :) |
|
|
|
JimEdwards
Starting Member
6 Posts |
Posted - 2006-05-24 : 14:26:06
|
quote:
Originally posted by Nigel Keith-Walker
The DTS packge is creating tables in a new database based upon tables in Access 2003.
Since I took one yesterday, I suppose it's only fair that I should give one today.  Where does your Access 2003 Database reside? If it's not on the server where your DTS is running, it may cause lock-ups because of the transactions being processed across the Network. I had this happen with a VB program that takes data from a SQL Database and uses it to update an Access Database. Here's how I fixed it:1. Make a backup copy of the Access Database.2. Copy the Access Database to the SQL Server.3. Run the program.4. Copy the updated Access Database back to its original location.Of course, if you are not writing to the Access Database, you only have to do Steps 2 and 3.Hopefully this helps.-Jim |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-24 : 17:03:24
|
| When you have this issue is anything showing up in the blocked column if you run sp_who or "select * from sysprocesses"?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Server Enterprise Manager