Microsoft SQL Server requirements

AVEVA PI Vision requires Microsoft SQL Server 2016 or above. Standard, Enterprise, and Express versions are all supported.

To leverage the same backup procedures used for PIFD with the AVEVA PI Vision database, we recommend that you host your AVEVA PI Vision database on the same SQL Server that PI AF uses, if using an on-premises Microsoft SQL Server for both AVEVA PI Vision and PI AF.

Ensure the SQL Server configuration setting Allow Triggers to Fire Others is set to True. Follow the steps below to verify this setting.

Note: The setting below applies if your database is on on-premises SQL Server or Amazon RDS for SQL Server. It does not apply if your database is on Azure SQL Database.

1. In SQL Server Management Studio, right-click your instance and choose Properties.

2. Select the Advanced page.

3. Allow Triggers to Fire Others is the first setting in the Miscellaneous section.

Note: For heavier loads (over 500 users) a full version of SQL Server running on a dedicated server is required.