I setup a new installation. Never set any support flags and the message is there. Microsoft, is the one that set those support flags. Also, which support flag # is...

Thanks. That is exactly what I was looking for.

Well, unless you have access to modify the application itself in order to modify the connection string then yest the application vendor (developer) has to make those changes. Unless there...

if it's a one time thing and the database is not complex (hundreds or thousands of tables with complex relationships) then I would do the following.

1. Recreate every single table...

Where you setup the SA account you will need to add one local Windows Account (your current admin account). That same screen.

"Before'n'After copies of the plans but we at least need the plans for the worst parts of the updates as they currently exist".

I might be bale to get the after...

Thanks everyone for the valuable information.

So as you all can see on this subset of the ETL - the times are taking longer. Some are parallel updates and some are...

Thank you everyone.

Unfortunately I do not have execution plans for previous ETL runs before the timing started to change. I only have logs of how long the times took. For...

1. Tables get truncated
2. Constraints get dropped
3. Bulk imports
4. Table updates
5. Index and constraints get created

Day in day out. Somehow 2 weeks ago the process is 30 to 40 percent...

Assuming an AlwaysON environment.

1. Pause any synchronization between nodes by Stopping secondary node.

2. Shutdown seconday node

3. Shutdown Primary node

4. Do the changes to storage

5. Bring Primary node online

6. Bring decondary...

For anything windows file related I recommend you use Powershell.

Create the Poershell script. Save it. Schedule a Task Schedule Job and run the Powershell at a specific time.

Create the login.. make it public. Don´t give any access there.

Go to the Database> Security ( add permisisons there under the account ) > select the account >

add permissions under...

Can you explain "We have 3 node in which 2 are SQL Cluster and 3rd one is Always On AG".?

But let's assume  you have a 3 node AwalysON AG, then...

Are both nodes in the same Subnet?

If they are not then the Windows Firewall turned off has nothing to do with you not being able to access the resource.

If you look at the Cluster Resources does it have the IP address of the Azure Load Balancer?

Does the AlwaysON Work? Failover and Failback?

Did you run the PoweRShell Script with...