Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2009-08-06 : 09:23:46
|
| We're trying to copy a large table (50 million rows) from one server running sql 2008 to another running sql 2008 and it runs a long time without finishing (cancelled it after 3+ hours). We can copy the same table from another server running 2000 to one of the servers running sql 2008 and it will copy within an hour. We are doing this with just a "select *" statement using linked servers. The sql 2000 server is a standalone server. The sql 2008 servers are virtual servers. Would the large run time difference be because they are virtual servers? If that is the reason, how come we can copy from a standalone to one of the same virtual servers within an hour? Let me add, the standalone server and the two virtual servers don't have a lot of other activity going on when I'm trying to run this. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-08-06 : 10:54:30
|
| Are the virtuals on the same disk as this can cause contention in itself? |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-08-10 : 16:42:44
|
| Depending on your virtual server hardware it could very easily be the cause. without newer hardware soem of the virtual servers i have used were up to 10-15x slower than running navively on the same hardware. |
|
|
|
|
|
|
table copy