AnsweredAssumed Answered

Sizing AF database including Audit Trail

Question asked by Roger Palmen on May 21, 2019
Latest reply on May 24, 2019 by Roger Palmen

For sizing an AFserver, the only think we have is the OSIsoft recommendations on the SQLserver sizing. But that does not take into account the Audit Trail.

E.g. i have an AF database with around 10K elements and 3M eventframes, and that would require 19Mb of Disk size.

However due to the audit trail we ended up with a database of 180Gb, which is an order of magnitude larger :-(

 

Any experiences / guidelines with this?

Any ideas about the impact (other than storage) on performance of SQLserver?

Outcomes