In order to ensure optimal performance of File Access Manager (FAM), be sure to reference both the official product documentation and the resources available via the SailPoint Compass Community. With respect to the latter, in particular, the File Access Manager Hardware Sizing Guide and the FAM Database Sizing Tool are resources that will inform adequate sizing and performance scaling of deployments.
