SQL Server Performance Forum – Threads Archive
DTS package & Scheduled JobIn my shop I have a DTS package scheduled at early hours of the day. It failed today with a deadlock error and I had to re run the job and it failed again saying deadlock situation. I can’t kill the process which is another important process happening at that time (blocking process). So, I decided to run the DTS package manually, and to my surprise it ran successfully without any deadlock errors, at that time the blocking process is still alive. Here, I had a question would the deadlock situations be captured in DTS pakcage run manually or automated ? Or is there something else which I need to know. Thanks in advance RoyalSher.
The world is the great gymnasium where we come to make ourselves strong.
What is the value of query wait option in sp_configure?
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Use following KBAs to monitor the blocking
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509 – for SQL 2000 blocking
http://support.microsoft.com/default.aspx?scid=kb;EN-US;251004 – for SQL 7 blocking And also try to capture the activity by running PROFILER while package is executed via SQLAgent. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.