Link to home
Create AccountLog in
Avatar of telliot79
telliot79

asked on

DTS from sybase to SQL optimization

Experts:

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:

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

MS SQL:
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.
ASKER CERTIFIED SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

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

ASKER

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.