Cheers for that.

Just to confirm, I can change the order they are in the list -- to alter the order in which they fail over?

Well, I was referring to this screen:

But looking at the properties again they have changed to all 3 being ticked as I expected. So now...

I've had this problem frequently on Compellent* SAN's where by a Replay (Snapshpot in Compellent parlance) that was turned into a LUN would mark all the files as READ ONLY....

Hi Jason,

This is a SQL Server 2014 (Enterprise) box. Has been running fine for 18 or so months and suddenly that on our smallest database, ironically.

I'll...

Well, curiously removing the database from the availability group caused all the redo's to start happening. Then I simply added back the database into the group. So far its working....

aha! found it here: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-hadr-cluster-transact-sql

whilst searching for something unrelated!

Hi Steve,

That doesn't give me the name of the cluster. That gives me the node name that owns the clustered sql resource (in terms of WFC).

I...

Cheers 'Fox

Oh. I think I have been being an idiot. A chronic condition.
I'd not realised there are two independent clusters being discussed.
I thought the illustrations were depicting a 4...

Howdy,

Well, CPU was pretty erratic because of a MAXDOP oversight... (and by oversight, I mean someone changed the Cost Threshold to 1 rather than the MAXDOP with a miss-click).

Hi Fox / Beatrice -- is this only for online index rebuilds?

Hi Perry,

Somewhere up in the above threads you mention a FSW at each site? Could you elaborate on that a little bit please? I thought an ideal FSW  is located...