Hi All, A customer is asking if SQL Always On is supported, and I can't find the answer. Does anyone know?
We haven’t tested or taken advantage of anything around “always-on”. It is a database level feature and not an application specific capability (i.e. it is a JDBC specific setting) that doesn’t require code changes.Our certification is for standard JDBC connectivity (without that setting enabled). It doesn’t mean it won’t work for our customers though as it seems to be RDBMS specific.
the requirements doc for 4.2 soi is clear not to use Always-on as the failover groups are not supported.
Database Requirements - CA Service Operations Insight - 4.2 - CA Technologies Documentation
I would love to know when CA will update the MSSQL driver in products like PAM and SOI and take advantage of this HA solution for MSSQL