June 6, 2002 at 12:40 pm
We use terminal services to remotely work on our servers. I don't think I should be able to DTS a large table launched from a server any faster than from my client.
My pc isn't doing any of the processing so it wouldn't be faster, right?
-K
June 6, 2002 at 2:37 pm
Well it depends. If the file is local to the Server in question then yes it will go faster. The reason is when you execute the wizard from you client the data must make a trip to your box then back to the server. If the data is on your box it should average the same. If on a remote box to both again will be faster as the trip to your box is going to occurr when executed from your client. And yes if you launch DTS from yuor client then DTS will execute the tranformation code on your computer so barring hardware differences such as amount of memory, cpu(s), hard drive type (paging file may be involved), then the server can outperform your client adding additional speed performances on the server as opposed to crossing the client. Hope that helps.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 6, 2002 at 4:23 pm
Tell me that isnt a design flaw! Running a package should execute it entirely on the server. I can see having the ability/option to offload the processing, but when I run a job I expect it to run on the server, why would a package be different!!
Andy
June 6, 2002 at 8:10 pm
I agree DTS has some major flaw. I hate worse than anything having to recreate a package I build on my machine when putting on the server. It would be nice to set the execution location.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 7, 2002 at 4:59 am
I transfer 40 million row talbes (fat tables)
quite often. You mean each one of those rows is passing thru my pc in between the 2 servers???
(not that you didn't say that clearly already)
-Kevin
June 7, 2002 at 5:25 am
That would be a real big YEP!
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply