Hardware requirements for PI AF server

PI AF is extremely flexible and supports the storage of many different kinds of objects. For example: a PI AF object can be as simple as a static numeric value or string of text, or it can be a much more complicated object such as PI Event Frames, custom data references, or even binary objects. As such, it is not possible to definitely correlate the number of PI AF objects to hardware requirements. However, there are some general guidelines.

Your hardware sizing should be based upon workload, not PI AF object count, because they do not correlate. As input and output (I/O) workload increases, it is important to ensure the disk subsystem can handle the I/O count as well as the storage requirements. Adding memory (RAM) improves SQL Server read and write performance. Increasing the number or performance of the CPU is helpful for concurrent users.