Thank you ,

I have been thinking about the moving the snapshot veeam back to the primary, but again I dont want to mess the primary node either.

Patching is definitely in...

I have tried the suspending and resuming but it does not fix the issue. We do have Veeam backup running on the secondary node that does utilize the snapshot tech....

One more, point to add... I have setup a VM in azure with backup going to a different geo location storage in azure. Also have used the feature disaster recovery...

Sorry, after reading it again , I might have confused the OP more.

Correction - .. Please try to re-run the select statement again but with adding the option (recompile) in...

Thanks for the input.

Will it be a good idea to have them scan the SQL Server binaries installed on C drive, for example, lets say , C:/Program files (x86). there...

If possible kindly ask the domain admin with the to create the cluster. they have domain admin permission to create the computer object for the cluster on the domain. Alternately,...

Please try running update stats on the table with the recompile option on the slow DB and run the query again.

It could also be that u have another SPn register for this service account on the domain. If you have permissions or the domain admin can run setspn to find...

Update: Based on the reading below (highlighted).

"In order to better design your database structure it is really important to understand how SQL Server works with multiple files within a...

If you are looking to set up windows failover cluster just as a requirement to setup always on ( like in a dedicated DB server). you dont need to share...

Thanks for the feedback.

the two nodes are in the same subnet. I was aware about the different sub-net issue however didn't think it applied in my case.
we...

Hi, Thanks for the response.

Yes, I checked it, once the fail over is complete, all the databases are up sync and available.

Regards

Hello.

I haven't had a chance to actually try and work with on the application server. However, just yesterday application guys send a snap-shot of the logs they say...