Performance issue on a singel large insert

Hi,

I'm testing Mirroing.

1) I have dedicated NIC for Mirroring - 100Mb

There is no issue with the network (file of 25MB goes in 2.5 seconds)

2) I'm issuing the next simple command

Select * into dbo.Table2 from dbo.Table1

3) the size of the table is 25MB

in async mode it takes 3-4 sec (as if it runs only local)

in sync mode it takes 25-29 sec !!!!

WHY IS THIS NORMAL

is there any configuration i can change

Zoetermeer
For more information on Database Mirroring performance look at: http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
Quilnux

Asynchronous operation permits the principal server to run with minimum transaction latency.

Check

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5264d6f8-3854-4e1a-a355-3db8219d9641.htm

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/39cda5cc-8957-4791-82ff-365a05dfb3c2.htm from BOL.
Speedbird186

That still seems long though, 30 secs for 25MB table

We had our mirrored database in sync mode while we did the credit card encryption

It was LONG (since everything has to get flushed to the mirror, and CC # are everywhere), but the network speed is high still

Although provided our NICs are Gigabit, as I wouldn't trust 100Mbps for mirroring
Performance issue on a singel large insert