AVEVA™ Products Feedback Portal

Welcome to our new feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, select the product of your interest in the left column. Then take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas will first be moderated before they are made visible to other users of this portal.

This page is for feedback for specific AVEVA solutions, excluding PI Systems and Data Hub. For links to these other feedback portals, please see the tab RESOURCES below.

Add a new idea Subscribe
Status Reviewing
Portfolio area Enterprise SCADA Server
Created by Jake Hawkes
Created on Oct 6, 2023

RELATED IDEAS

Add support for partitioning on SQL2019SE and update guidance to use SQL2019 SE vs EE

This enhancement would allow partitioning to be enabled when using Standard edition. Not all tables will need partitioning, so some way to be able to choose whether a table is partitioned or not will be required.

There are customers that want partitioning, and think that the standard edition functionality is enough. However, it could be that what we benefit from the most is actually parallelism (which depends on partitioning), which is explicitly excluded from Standard.

Our research hasn't revealed that that using partitioning on SQL standard will give the performance gains it does on SQL enterprise due to other missing features like parallelism.



Expectation

Support SQL Server Standard Edition with table partitioning

Idea business value

SQL Server Enterprise is 4x the price of standard. With back-up and DSS, this could be upwards of $30k extra in licensing, which for smaller systems represents a significant portion of the total licensing cost.

SQL Server SE is significantly cheaper, and there is a growing desire to enable the product to use it with partitioning. However, these two facts seem to be opposed to each other: a large system should probably consider SQL Enterprise for other reasons.
Idea Type Improvement
Idea priority 3 – Some use to my company
User Persona SCADA Administrator, IT/Network Administrator
Work in
OASYS-277 Add support for partitioning on SQL2019SE and update guidance to use SQL2019 SE vs EE
Work status
  • Attach files