SQL Server Loads over Network take forever

[Chris Trendle]

When I attempt to load a database from dump format across a network (100mb Ethernet) It takes forever. (15 hours for 16GB!) can anyone help me find a starting point to troubleshoot this?

Thanks!

-Chris

P.S. File Copies of the same size move at a rapid fashion, and I cannot find any bottlenecks in the network.

[Ray Miao]

On 2/16/99 4:54:42 AM, Chris Trendle wrote:
> When I attempt to load a database from dump format across a network (100mb
> Ethernet) It takes forever. (15 hours for 16GB!) can anyone help me find a
> starting point to troubleshoot this?

Thanks!

-Chris

P.S. File
> Copies of the same size move at a rapid fashion, and I cannot find any
> bottlenecks in the network.

Use network monitor tool (sniff, etc.) to start your troubleshooting.

[Craig]

On 2/16/99 7:30:12 AM, Ray Miao wrote:
>
On 2/16/99 4:54:42 AM, Chris Trendle wrote:
> When I attempt to load a
> database from dump format across a network (100mb
> Ethernet) It takes
> forever. (15 hours for 16GB!) can anyone help me find a
> starting point
> to troubleshoot this?

Thanks!

-Chris

P.S. File
> Copies of the
> same size move at a rapid fashion, and I cannot find any
> bottlenecks in
> the network.

Use network monitor tool (sniff, etc.) to start your
> troubleshooting.
++++++++++
Also look at the documentation on TcpWindowSize if you are using TCP/IP..Craig