Did futher diagnostic work - the sending rate had an approx. average of 40 MB/sec and the principal sent 37 GB to the mirror node in 15 min.

The restore rate...

Thanks - i've also reached out to Microsoft... I'll post back any information I receive.

Response to questions.

Lynn - I asked the same question to many individuals w/in my organization.

Short answer - 'Because RAM would be faster. See if it is possible.'

Elliott - Agree, 1...

My apology for being unclear.

Technically - we have two data drives.

X: all database files (except TempDB) on a large drive residing on 4 FusionIO cards.

Y: TempDB residing on 2 FusionIO...

run on each database - it will break it each table by MB.

select object_name(id) [Table Name], [Table Size] = convert (varchar, dpages * 8 / 1024) + 'MB'

from sysindexes where...

The 'SQL Change Report' mentioned is in fact the Schema Changes History report.

Unfortunately, I need to reduce some of the noise in the report and have more control of the...

Was the database rebuilding indexes?

In the past, my sql mirrors have gone to a suspended state when rebuilding really large tables.

Matt

Can you ping each server via IP? If ping works, verify the connectivity via telnet as SQL Mirroring uses this protocol. Test from both principal to mirror and then...

Have you looked at the Database Mirroring Monitor in SSMS?

SELECT percent_complete, estimated_completion_time FROM sys.dm_exec_requests where session_id = 855

order by session_id

session_ID is the spid performing the process.

Not sure if this is what you want....

select 'table_name'=object_name(i.id)

,i.indid

,'index_name'=i.name

...

Long story short - I run FusionIO cards in production (4 X 1.2TB DUO Cards for one logical drive and 2 X 640 DUO cards for 2 logical drives).

Well, come...

Is hyperthreading enabled on the new server?

If so - consider turning it off.

Just an update.

declare @b-2 varchar(200)

declare @value varchar(10)

set @value = 'w1w 5pa'

EXEC @b-2 = LinkedServerName.DBNAME.dbo.FunctionName @value

select @b-2

I am not using a witness server.

I think I will pause the mirrors prior to the reboot as a precautionary measure.

Thanks for the response.