What vesion of SQL Server is involved?  Is it 2012, 2014, 2016, etc.  Also, why are you saying you need Enterprise Edition on your failover cluster?  You can set up...

For AlwaysOn AGs, you can look at there is an extended Events Health Session that can be examined to find information about failovers.  I would also be curious to know...

My question would be, why do you want to mix replication and AlwaysOn Availability Groups?  What problem are you trying to solve by doing that?  Mixing them is going to...

My advice or tip would be to run the Database Migration assistant against your 2012 instance prior to the upgrade to SQL Server 2017.  It will examine the databases and...

Any reason your spending your precious time building a monitoring tool when there are so many good off the shelf options that have tried and true methods?  You're going to...

The concept HandyD proposed will work fine with Availability Groups, but instead of pointing a CNAME to a specific SQL instance, point it to the AG  Listener.  We've been doing...

Thanks Jeff.  I appreciate it.  The databases are going to grow and dedupe isn't particularly effective for SQL.  I do have some databases with compression enabled where it makes sense. ...

Thanks Steve. That makes sense to me.

Take a look at this library of wait types from SQLSKills.

Also, do you have any moniotring tools in place, like Database Performance Analyzer?

https://www.sqlskills.com/help/waits/

Thanks, I understand that part. What is the difference between SQL Server Failover Cluster and SQL Server Failover Clustering Instance?

Does instance mean one node of SQL Server Cluster, or...

Sue, We were simply trying to see if this migration would work on a lower version.  We actually ended up updating the versionnumber column in the DBUpgradehistory table to 163...

Now seeing this in the ReportServerservice log file in the 2014 SSRS instance.  Part of this is the same error I'm seeing on the 2017 instance.

library!WindowsService_5!1a64!08/23/2019-03:44:41:: i INFO: Current DB...

There is a database upgrade process that is failing.  At least that's what another part of the SSRS logs indicate.

Last night I tried to restore the SSRS databases to a...

Thanks Chris.  Maybe that would work?  If I ever get the migration to go successfully, I may give this a try.  Have ran into a lot of problems moving this.

I've used Aliases before, so I know it's possible.  Did you setup the same Alias under both "SQL Native Client Configuration" and "SQL Native Client Configuration (32bit)"  ? Also...