sql-serversql-server-2012alwayson

SQL AlwaysOn - What if you don't use it as a cluster/failover?


I've been proposed a concept of using two SQL servers using AlwaysOn as a form of replication.

With the Primary receiving all data, the secondary being a readonly server for a reports source.

Since this feels like the proposal is uncertain as there is no information on configuring something like this, would anyone know if this is a good or terrible idea?

ADDED NOTE: There is no clustering or AG listener. Servers are grouped, but accessed and addressed directly.


Solution

  • Starting SQL Server 2017 there is no need for Clustering or Listener to deliver a solution for your scenario.

    Few things to consider though:

    Therefore, AlwaysOn AG readable secondaries have pros and cons in comparison with log-shipping:

    Regarding your question:

    would anyone know if this is a good or terrible idea?

    AG readable secondaries are definitely worth of POC trial, especially if your company has required skillset/resources

    (Disclaimer: this post is based on my personal opinion)