I have been working with Contained Availability groups for the last few months and I am NOT impressed so far.

Hope this answers your questions:

You cannot use a Contained Availability group...

I spoke to a Server Administrator and he mentioned that Yes TLS is enabled by default on Windows Server 2019 and that all three versions are enabled 1.0, 1.1, 1.2. ...

Folks, I did find the below website that talks about TLS settings.  From what the site is saying it might be enabled by default and you can use the registy...

OK thank you.

I have a quick questions

If I installed Cumulative Update 16 for SQL Server 2019 and then installed GDR 16 for SQL Server 2019 - will I be able to install...

Thank you for the feedback on this topic.

The developer tested after making these change and the performance has increased.  The job that imports the 120K records are only taking 2...

Thank you very much and I like your feedback.

I was pulled off the project for a bit and will resume on Monday and will be able to address your comments.

Thank you very much for the reply on this.  I am still working on this project.

I have build a new server and added it to the cluster in the primary...

Thank you very much for the feedback on this topic.  See my answers below:

Do all nodes in the cluster have access to the file share witness?  If they are on...

Thank you very much for the feedback

I will first test the database on a cluster where there are two nodes in the same datacenter and while trying Synchronous and Asychronous...

Thank you very much - that is what I thought.  I marked your reply as "Answer"

Thank you very much for the help on this subject and sorry it has taken me so long to reply to this, but I was able to run a test...

Thank you very much for the help

I will use the SP_help_Revlogin to recreate the logins on the secondary

I will also try the query see what the results are.

Thank you very much for the feedback

The RDP time out is by design from the Server team and they tell me to use a VCenter console if I do not...

• This reply was modified 5 years, 3 months ago by jayoub.

Thank you very much for the feedback.  Below are my comments and follow up questions

First - I'd recommend against cross posting. I found your post on here, Microsoft and VMWare....