Thursday, March 22, 2012

DTS Performance Issues?

I have roughly ~80 machines periodically performing DTS transfers to a central server. The central server apparently can't handle this load. When watching in the performance monitor, after about one hour of being online, disk use is steadily pegged at 100% and the server becomes unresponsive. How do I track this down further and further diagnose/resolve this performance issue.

I can look at the current activity window but I don't know how to interpret or use the results.

thanks!Roger,

I wonder would it be easier to pull the data rather than push from the 80+ clients ? At least the server would be able to schedule them sequentially.

How much data are we talking about here ? Improvements might be made via indexing etc on the server table side ?

Mark|||Just a thought, may be you can export the data to a media as files and have the server import the data from the media as file import one by one.

No comments:

Post a Comment