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.
Showing posts with label apparently. Show all posts
Showing posts with label apparently. Show all posts
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:
Posts (Atom)