It's worth looking at the cluster event log on the server for any errors. Also there should be a diagnostic extended event file in there. The...

Have you looked at the AlwaysOn dashboard to see whether there are any warnings? Is there any errors in the SQL Server error log?

That's correct, SQL Server 2014 and Windows Server 2012 R2

Yes that's correct

Yes that's right, I only specified one in the detail as to keep things simple. No startup trace flags/parameters are set.

The SQL server cluster roles SQL Server (CORE)...

SP1 now available

https://www.microsoft.com/en-us/download/details.aspx?id=46694

Here's some more info showing config of AG and SQL Server cluster roles and resources.

Also showing the steps I took to move role between nodes of FCI. Again just...

Apologies here is the attachment

Hi Perry, thanks for your prompt reply. I have read your 'Stairways to AlwaysOn' series and found it extremely helpful in the set up of our AlwaysOn solution.

I have...

The view has a start time and date so could base a query off this and the expected run time for the subscriptions. You could possible join the...

Could well be a datatype issue. Were there any warnings on the 'review datatype mapping' page?

That's not a valid method of outputting to an excel format. If you're doing that way you'd be best to try outputting to comma tab delimited file, then open...

Just remember to reorganize your indexes after

Here is a an alternative solution

•Create a new filegroup

•Move all affected tables and indexes into the new filegroup using the CREATE INDEX … WITH (DROP_EXISTING = ON) ON ...

The stored procedure would error when trying to query the linked server that was down. It should recompile ok as the linked server itself is there

You could possibly do...