Symantec IGA

  • 1.  SQL Always-On supported?

    Posted Mar 22, 2018 07:01 AM

    Hi All, A customer is asking if SQL Always On is supported, and I can't find the answer. Does anyone know?

     

    Regards, Eric.



  • 2.  Re: SQL Always-On supported?
    Best Answer

    Broadcom Employee
    Posted Mar 26, 2018 09:19 AM

    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.



  • 3.  Re: SQL Always-On supported?

    Posted Jun 04, 2018 04:44 PM

    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