Recommended approach for PI AF high availability

To implement high availability for PI AF, we recommend the following measures:

• Deploy the PI AF application service on multiple computers and the PI AF SQL database on another set of two or more computers. We recommend that the PI AF application service be configured to run under a domain account.

• Configure the PI AF SQL database computers as an Always On availability group.

• Set up a network load balancer that manages all communication between PI AF clients and the PI AF application service tier.

  

This recommended configuration is based on the following technologies:

• Windows Failover Clusters for an Always On availability group

• Network load balancing, to distribute PI AF client-to-PI AF application service communication

  Note: We assume you are familiar with the configuration and operation of network load balancers, Windows failover clusters, and the cluster administration tools provided with the Windows operating system. For an overview of Microsoft high availability solutions, see the Microsoft article Business continuity and database recovery - SQL Server.