Currently they both reside on same sql server 2012. So one application is okay to upgrade to SQL 2016 the other one has to stay on SQL 2012. I would...

Secondary Replica 1 is on VM. So Always- On can be configured for Virtual server right?

Thanks. I notice that you can configure the SSMA to batch the data move and control the batch size. The question is when the migration is initiated for approx 1...

I have seen issues using with migration assistant for loading large data. Do you think SSMA is not a good option for migration large database? Any major issues you can...

Stack dumps are not readable. Logs are not indicating the cause for the stack dumps. Does reading stack dumps need tool only Microsoft can help? Any other thoughts?

Thank you!

Thanks Sue! I totally agree what you said.

I am sorry about the confusion.

Also, my understanding is Execute permission is not sufficient for compile a SP? If this option is used when the procedure definition is created, it requires create procedure permissions in...

Sorry i mean to say compile. Compile and execute access for SP's.

Looking for better way to grant recompile store procs permissions? Any advise?

That sounds to be a valid point. I really appreciate it. All i know is sql server you can grant access to execute store proc and is their anything specific...

Thanks. I don't have any thing specific in my mind. I am making sure if there is anything to worry about. However, i am also making sure to grant access...

Regarding comment from chris, it says replication limitation for sql 2016..But it doesn't say about SQL Server 2017.

Here's a link to some documentation about in-memory tables and the feature limitations:

https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/unsupported-sql-server-features-for-in-memory-oltp?view=sql-server-ver15

It...

Without knowing much other than the data insert and select. How much memory to start with on the server. Is there any ballpark?