Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: 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!

  2. #2
    Join Date
    Oct 2003
    Location
    Ireland
    Posts
    54
    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

  3. #3
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: DTS Performance Issues?

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •