Dear All,
We need help on the following issue:
Our DTS packages take >50 % longer to complete when we move our application from test server to production server.
Our test server is a normal PC turn server with pentium4 2.4Ghz, 1 GB RAM, 40 GB hard disk and windows 2000 server.
The production server is IBM Xseries 445, dual xeon 3 GHz CPUs, 4 GB RAM, lots of disks and Windows 2000 advance server.
The package is importing 300,000 rows of delimited text files to database with some calculation. There is no other application running on the production server, not even the antivirus. Other functions such as enquiries, reporting, master file update are running faster.
Can someone give us a clue why the DTS slow down.
Thank you in advance.
We need help on the following issue:
Our DTS packages take >50 % longer to complete when we move our application from test server to production server.
Our test server is a normal PC turn server with pentium4 2.4Ghz, 1 GB RAM, 40 GB hard disk and windows 2000 server.
The production server is IBM Xseries 445, dual xeon 3 GHz CPUs, 4 GB RAM, lots of disks and Windows 2000 advance server.
The package is importing 300,000 rows of delimited text files to database with some calculation. There is no other application running on the production server, not even the antivirus. Other functions such as enquiries, reporting, master file update are running faster.
Can someone give us a clue why the DTS slow down.
Thank you in advance.