February 3, 2006 at 12:58 am
Hi all,
we have an development-server, an integration-test-server and a production server. the integration-test-server is new. we do ETL via ODBC from an iSeries (AS400). the transfer time for a large file (20Mio records) is quite good on the old servers, but it is poor on the new server. we can't see any differences neither in the W2K3-setup nor in the SQLS2000-setup of our 3rd server.
regards
ralf
February 4, 2006 at 6:44 am
What hardware difference is there between the integration-test and production/development server?
February 6, 2006 at 1:00 am
there are no differences. all servers have 8GB memory and the same cpu-power. Is it possible that the new one does not use all of its 8GB? If so, are there any parameters outside SQL-server software (on the operating system) that are not correctly adjusted? Ralf
February 6, 2006 at 10:58 am
Are the execution plans the same on all server?
You can see how much memory uses with performance monitor & sql counters.
The new server, does it has the same RAID/SAN implementation?
Linked server/collation have the same options?
ODBC driver same version?
February 7, 2006 at 2:25 pm
I am going to check this.
Thanks
Ralf
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply