Link to home
Create AccountLog in
Avatar of telliot79

asked on

DTS from sybase to SQL optimization


i'm attempting to transfer data from my Sybase A.S.E. 12.5 database to as MS SQL 2000 database server and am looking for some information to optimise the transfer. I've a made a series of configuration changes (which I'll outline below) but still am only seeing about 1% of my network utilization - my link speed on the network is 2 Gbps. Where could the bottle neck be and what can I do about it?

Here the changes i've made to the databases:

increased "max network packet size" - this had a small increase but not much

created new drives from different sections of our SAN
split the database over the drives with multiple mdf and log files.
split the tempdb into multiple mdf and ldf files and seperated them

I'm still testing, but it nothing I do seems to be able to speed the network utilization up.

Any help would be much appreciated.

Thanks in advance.
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of telliot79


sorry for the delayed response.

these things did help my optimization, but my main bottle neck seemed to be poor db maintenance on the sybase side.