Perry Whittle has some excellent articles on this site for various High Availability configurations

Enjoy

Regards

That's why I said "I think..." Wasn't sure - Thanks for clearing up

No Problem

😎

Yes it will

Principal, Mirror and Witness constantly Ping each other - The Partner Timeout is how long after NOT receiving a reply must it perform an automatic failover. I think...

Partner Timeout is more to do with your network latency and how far Mirror and Partner are physically apart from each other - Database size plays little part here

Ok - You mean, how long will it take for the Mirror to take over as the Principal

As far as I know, it should be instant

Remember that your mirroring session...

Use the local_net_address column of sys.dm_exec_connections

Something like this to get server name and IP

declare @subject nvarchar (100)

declare @v-2 nvarchar(50)

set @v-2 = convert (nvarchar (50),case when CONNECTIONPROPERTY('local_net_address') is null then '' else CONNECTIONPROPERTY('local_net_address') end)

print @v-2

set @subject...

Perhaps I'm missing something here but I'm still not sure what you're asking

What do you mean by "Intervals"?

Mirroring is realtime which means that transactions are committed at both partners in realtime - Depending on your mirroring mode - Synchronous or Asynchronous

That is definately not normal

Something happened during/after the reboot.

Check error logs etc..

Those results are not conclusive enough to point you in a decent direction as to where your performance problems are.

You could look at your worst performing queries that are still...

What is among your top waits?

Have a look at the wait statistics on the server

SELECT TOP 15

wait_type ,

wait_time_ms ,

signal_wait_time_ms ,

wait_time_ms - signal_wait_time_ms AS resource_wait_time_ms ,

100.0 * wait_time_ms / SUM(wait_time_ms) OVER ( )

AS percent_total_waits ,

100.0 *...

I forgot to mention that after changing in to Async, I changed it back to Synchronous - Still same issue, automatic failover not working

Thanks