snippetsqlMinor
Should I create two endpoints for two availability groups on the same SQL Instance?
Viewed 0 times
samegroupsthecreatesqlendpointsinstancetwoforavailability
Problem
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.
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.
Solution
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.
An endpoint is for instance of SQL Server and all Availability Groups configured within that instance can use this endpoint.
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.
An endpoint is for instance of SQL Server and all Availability Groups configured within that instance can use this endpoint.
Context
StackExchange Database Administrators Q#237313, answer score: 6
Revisions (0)
No revisions yet.