I am running a 2-node MSSQL 2012 AlwaysOn cluster. We will be hosting SCOM, WSUS, and a few other databases in this instance. In all cases we would like to maintain some level of failover however is provisioning an Availability Group Listener necessary for all AGs?
In other words, take WSUS for instance. I would like the database to be resilient however wouldn't it be sufficient to connect to the cluster name instead of creating a listener (and wasting an IP address) when we do not need to have readable secondaries or span multiple sites?
When is an AG Listener necessary and when it is not under such a 2-node deployment?