SQL Server Performance Forum – Threads Archive

Error 8522

Hi, I have a DTS Package that runs a distributed query on another server to extract data and load it in a local working table.
During the execution, the task that runs this query work for 12 minutes and stop presenting the message: "Distributed Transaction Aborted by MSDTC" I just tested the conections and distributed transactions with few rows between the two servers, and it’s all right.
If I change the remote server to another server, the task work fine. Configuration of the remote server (problems) – 8 processors with 700 MHz (Pentium III)
– 8 GB of memory
– The datafiles are located on a Clarion CX400 with 2GB of cahe. Configuration of the remote server (OK) – 2 processors with 2.8 GHz (Pentium IV HT)
– 4 GB of memory
– The datafiles are located on the same Clarion CX400. Obs: All servers are conected on a 1 Gigabit local network. Please, someone can help me?

You haven’t mentioned the version of SQL Server used and its service pack. KBAhttp://support.microsoft.com/default.aspx/kb/306212?
KBAhttp://support.microsoft.com/default.aspx/kb/839187 .. to tackle the issue. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thank you Satya. All servers with SQL Server 2000 Service Pack 3 (Hot fixes applied resulting in the version 8.00.952)

Then the above referred KBAs will do the rest. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>