A thread on here states that for SharePoint using AOAG, the recommendation is to use the listener and no alias.

That's fine but one of the things I do is I use two seperate SQL Aliases on a standard clustered setup. One alias for search databases (which can get big), another for everything.

This way I have granularity in moving just search databases, if required.

How could I do this with AOAG listeners and SharePoint?

1 Answer 1


You can create two AOAG groups on the same sql servers.User AG 1 for everything and AG2 for the search.

I think two groups also help u in performance.

  • Presumably then I need two listeners? If possible?
    – GurdeepS
    May 3, 2017 at 8:56
  • Yes you need two listeners and I have this thing in one of my deployment.
    – Waqas Sarwar MVP
    May 3, 2017 at 10:42
  • Ok thanks, that makes sense. One more question:- In a SQL Cluster with named instances, what does the SQL alias use? The cluster network name (which shows up in the SQL Server properties), or networkClusterName\instanceName (of node)?
    – GurdeepS
    May 3, 2017 at 22:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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