3

I have a two node cluster running SQL Server 2012. I want to create two Availability groups within the same instance of SQL Server.

Should I add one endpoint for each AG, or shall I allow both AG's to use the same endpoint?

I have read the documentation here but the only part pertaining to multiple endpoints relates to multiple SQL instances

Note that if more than one server instance on a given computer requires a database mirroring endpoint, specify a different port number for each endpoint.

4

If you read Prerequisites, Restrictions, and Recommendations for Always On availability groups it says

Each server instance requires a database mirroring endpoint. Note that this endpoint is shared by all the availability replicas and database mirroring partners and witnesses on the server instance.

And endpoint is for instance of SQL Server and all Availability Groups configured within that instance can use this endpoint.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.