You're awesome. That's really a great input from you. Also, planing to implement Always on with DR(Asynchronous) and Reporting(Synchronous) on the same DB system. Do you see any issues with...

Thanks! Sue, Can you please shed some light like what are the historical information i can look into so that i can come up with some recommendation in terms of...

Thanks to everyone. So my understanding is that prior to SQL 2016 the BizTalk uses SQL Server Fail over Clustering and Log Shipping to provide high availability.

But from SQL 2016...

Any input would be appreciated! Thanks in advance!

Thanks! It does meet the needs. However, i would think it has more processors than what we need? Not sure if we can trim the processors?  My understanding is that...

Thanks Sue!

Doesn't look there is a already groups in AD. Would you rather see the AD group modified to grant all users the same access, or setup individual accounts?

So restoring the ssisb did not create the master key. Is the jobs run using sql agent for SSISDB? If yes, then i restore the SSISB to new server then...

I did not create master key.I restored the SSISDB database to new server. However, i noticed there is no environments is created on the original server. Does it mean that...

Thanks! So you won't recommended this and there could be problems it depends? I agree the purpose of monitoring tool is for different things. But it is still manageable to...

Can you think of anything that could cause the problem?

I can open tcp connections to 3343 and 1433. What other ports you can think of required for availability groups? Please advise?

Thanks Sue! I didn't kill the process but below error is what i am seeing in the log.Does it mean someone killed the session or it is interrupted by other...

Never mind. I could able to make progress with above issue. However, i came into below issue this time for adding the DR server in different ip range.

Cluster node "C"...

Any more you can suggest?