It's transactional replication. I agree AG will not failover to async node but when we loose all synchronous node and when we have to bring the databases up on async...

Exactly, so in your configuration why have you removed a vote from a perfectly suited node and then gone to all the hassle of deploying a fileshare witness on the...

A question for you

You have nodea and nodeb on site 1 and node c on site 2, you have configured quorum for Majority Node Set, each node has a vote

The...

Perry,

I was referring to this document, on disabling the vote system--

https://msdn.microsoft.com/en-us/library/hh270280.aspx

Exclude secondary site nodes. In general, do not give votes to WSFC nodes that reside at a secondary...

Your original post says you have a 2 node cluster but you have a 3 node cluster. Please ensure to post accurate details in future.

Further questions are

Is the prod cluster...

Windows server 2012 R2 Standard

yes, it's a multi site cluster with...

got it.

Thanks Gail. I agree with you it's very complex. We are just in the initial phase of reviewing this new architecture. At the end might settle down with what you...

GilaMonster (8/18/2015)

---

After the fact, no, probably not.

If you have an app that's still inserting/updating the column with encrypted values, then a server-side trace may show you what function and key...

GilaMonster (8/17/2015)

---

What you're asking there is seriously, seriously complex. If you really want read-write on all nodes, then peer-to-peer replication (or maybe merge replication) is the only option, but to...

Perry,

we went through cluster validation tests. Everything was working fine from last 8+ months. We applied WSUS and SQL2014 SP1 on the box prior to failover. That's when we started...

I did tried that one, but same result. Now I am getting the below error:

failed to designate the local availability group replica to AG.

@Gila- So is there any query to find which process is consuming memory in NONbufferpool?

Any suggestions?

Thanks Gila for the response.

So currently on my Prod server i have 30Gb Ram and i set the max server config to 23552 Mb and Min server config to 1024MB....