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.
Thursday, March 22, 2012
DTS Performance Issues?
Labels:
apparently,
central,
database,
dts,
handle,
load,
machines,
microsoft,
mysql,
oracle,
performance,
performing,
periodically,
roughly,
server,
sql,
transfers
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment