Help, took 18 hours to COPY 113 million rows
Anybody have any insight into why the Windows performance is so poor? I am trying to restore a database (55GB total) and it took 18 hours to insert into my first big table. The CPU and Disk was less than 25% the entire time; with complete periods of zero activity. Attached is a screen show of the moderate cpu 28% and minor disk and the disk is **only** reading the dump file by mclient. -- ------------------------------ This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.
participants (1)
-
Bryan Senseman