使用 AVEVA PI Server 的云管理 SQL 减轻管理开销.pdf

1、Offloading admin overhead with cloud-managed SQL for AVEVA PI ServerScott Seeman,R&D Senior Member of Technical Staff,AVEVAAPRIL 9,2025R&D Senior Member of Technical StaffScott Seeman 2025 AVEVAGroup Limited or its subsidiaries.All rights reserved.AVEVAWith AVEVA since 2018All 7 years working on Ass

2、et FrameworkAVEVA WORLD 2025Agenda 2025 AVEVAGroup Limited or its subsidiaries.All rights reserved.Why host PI Asset Framework SQL Database in the cloud?Whats new in 2024 R2?New installationsMigration to the cloudAudit Trail supportOffloading admin overhead with cloud-managed SQL for AVEVA PI Server

3、Moscone West CenterSan FranciscoWhy?Benefits of cloud-hosted SQL?Decrease admin work so staff can focus on operations data value Ease cloud migration and offload AF SQL admin tasks to Microsoft Azure/Amazon AWS Lower costs from IT overhead and on-demand usage with more automation 2025 AVEVAGroup Lim

4、ited or its subsidiaries.All rights reserved.This will be of great value to all Global Business Units for the Company I work for as we migrate PI AF and Vision to Azure Cloud.Our IT costs for licensing and managing/maintaining many SQL Server environments is reduced as well as improving our availabi

5、lity and security in the Cloud.We would like to focus on our core task(data analysis and turning data into value)keeping servers running,taking backups etc is not our core business130 Combined votes for Cloud SQL SupportWhats new in PI Server 2024 R2?2025 AVEVAGroup Limited or its subsidiaries.All r

6、ights reserved.PI Server 2024PI Server 2024 R2Azure SQL DatabaseAzure SQL Managed InstanceAmazon RDS for SQL ServerAudit TrailAsset Framework ClientAsset Framework ServerAsset Framework SQL DatabaseOn-PremiseCloud SQLRunning SQL scripts for new installations 2025 AVEVAGroup Limited or its subsidiari