SQL Server Performance Forum – Threads Archive
DTS performance
i have a DTS package that does a "copy sql server objects". it takes 30 minutes to transfer data to one location.60 minutes to another different physical location.(located further from source data) looking at the network perf. counter i see the Bytes Total / Sec is twice as high for the 30 minutes transfer. (makes sense) my question is how can i speed SQL Server up so that is can transfer this DTS data faster? there is no Disk Queuing issues at any time during these transfers. i know DTS does a Truncate Table, Select * from table, Bulk Insert into table. – i tried doublling the Network Packet Size in sp_configure.
– also disabed Named Pipes cause I know this is slower when going longer distances.
(neither of these things speed it up)
any ideas?
Dump/copy the objects into a working DB, detach the working DB, move the working DB’s files to the remote server, attach at the remote server, then process on the remote server?
don’t really want to do that. are there any sql server configurations that can make it transfer this data faster?
also seeing that the
Bytes Total / Sec varies greatly depending on the table DTS is copying from. wierd. cause all of these are Select * from Table. not seeing and locking/blocking issues either.
Check this
http://www.sql-server-performance.com/dts.asp —————————————-
http://spaces.msn.com/members/dineshasanka
Few more
http://vyaskn.tripod.com/sql_server_dts_best_practices.htm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_usage_7703.asp
http://www.informit.com/articles/article.asp?p=23571&rl=1
http://www.databasejournal.com/features/mssql/article.php/1499481 —————————————-
http://spaces.msn.com/members/dineshasanka
Please post your DTS questions in the DTS section
Moderator, Please move this to DTS section —————————————-
http://spaces.msn.com/members/dineshasanka
read all these before. anyone have any personal expereinces in speeding up sql server data transfers?
]]>