I like the idea of suspend data movement. Would this cause the log to grow until the upgrade runs? My understanding is the backup jobs will be still running on...

Thanks. Since the application cannot be down. We have 2 secondary replica, 1 for DR and another for reporting with Async mode. So I am thinking to remove the reporting...

What do you think about schema changes history? How long does it keep the history?

What I found is PolyBase act as a virtual data layer to integrate structured and unstructured data

Thanks. How about the database name standards?

• This reply was modified 2 years, 6 months ago by  sqlguru.

The wait stats I am seeing is LCK_M_U, WRITELOG and LCK_M_S are they normal behavior or something to be looked into it?

So that will end up with changing the server IP address? It is our current production server? Would changing the IP will have any impact?

That scope is full. Unable to move or decomm any other. I would need to come up with another plan.

Would changing the IP address of the node is the only...

Thank you sir!

I was thinking of failover test to ensure the replication is working when primary becomes secondary? Any other thoughts?

Thanks! During the seeding process if I use the option of backups then I would not be doing log backup until the seeding is finished right?  Or then I have...

The log I provided is from windows event viewer. I know when it started, but I am trying to find who started?

Connecting to server works but when connecting using listener it times out. Any thoughts? Thanks in Advance!

Using listener there are timeouts from application. Does increasing the session timeout is advisable from availability group properties?

What's your thoughts on cross database ownership chaining? I have tested and it works. Is there any security risk?