CA Service Management

  • 1.  CA Service Manager and MS SQL Always On Cluster

    Broadcom Employee
    Posted Feb 13, 2019 05:29 AM

    Hi All,

     

    do you have any consideration regarding CA SM (rel. 17.1) to be using an MS SQL Always On Cluster? Any compatibility Issue, any good experience on this?

     

    This is in order to implement HA at DB level.

     

    Thanks in advance,

     

    Vito



  • 2.  Re: CA Service Manager and MS SQL Always On Cluster

    Broadcom Employee
    Posted Feb 14, 2019 05:08 AM

    Good Morning Vito.

     

    Please check on this one: MS SQL AlwaysOn support 

     

    Does that help you further?

    Kind regards, Louis.



  • 3.  Re: CA Service Manager and MS SQL Always On Cluster

    Broadcom Employee
    Posted Feb 14, 2019 05:14 AM

    Hello Louis,

     

    yes it helps.

     

    Thanks a lot for your suggestion,

     

    Vito



  • 4.  Re: CA Service Manager and MS SQL Always On Cluster
    Best Answer

    Broadcom Employee
    Posted Feb 14, 2019 05:14 AM

    Good Morning Vito.

    Please check on the below then too?

    There has not been any changes to the Always On feature in regards to SM 14.1 and 17.1 product version
    The answer is yes, SDM 14.1 version is supported for Microsoft SQL Server "Always On".
    And you can find the technical document below link:
    https://comm.support.ca.com/kb/which-version-of-ca-service-desk-manager-can-be-used-with-the-always-on-high-availability-option-of-microsoft-sql-server/kb000012124

    And this one:
    Supportability Matrix
    https://docops.ca.com/ca-service-management/17-1/en/ca-service-management-17-1-release-notes/supportability-matrix
    Showing for Database: The following databases are certified on 64-bit.
    Support for Always On feature in the Microsoft SQL Server, with the exception of Unified Self-Service 17.1

    Kind regards, Louis.



  • 5.  Re: CA Service Manager and MS SQL Always On Cluster

    Posted Feb 15, 2019 10:48 AM

    What are the use cases for Always On with regards to Service Desk?  I don't think it can be used for offline reporting because it replicates all tables (like log shipping), including ones that should not be replicated for the offline primary server.



  • 6.  Re: CA Service Manager and MS SQL Always On Cluster

    Broadcom Employee
    Posted Feb 15, 2019 10:51 AM

    Hi Jonh,

     

    thanks for your point. There is not a particular use case but General Cluster DB architecture.

     

    I will forward your warning to guys on field to take into account.

     

    Cheers,

     

    Vito